2011/7/6 e-mail mgbg25171 :
> 1990 1991 year <= dimension
>
> north sales 10 8
> cogs (5) (4)
> south sales 6 5
> cogs
Luuk, Roger
Yes it is like a pivot table.
I was stuck on how you delete dimensions you decide you don't want anymore.
After a day thinking about it I think I've cracked it so...
Thanks very much for your assistance.
___
sqlite-users mailing list
On 06-07-2011 17:30, e-mail mgbg25171 wrote:
> 19901991 year <= dimension
>
> north sales108
> cogs (5) (4)
> southsales 6 5
> cogs (2)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/06/2011 08:30 AM, e-mail mgbg25171 wrote:
> I just want to be able to specify different dimensional values and get back
> rectangles of data that I can manipulate.
Is what you are trying to do the same thing as pivot tables in spreadsheets?
If
19901991 year <= dimension
north sales108
cogs (5) (4)
southsales 6 5
cogs (2) (1)
regionline item <==
Simon only just saw your post so hope my image didn't come through.
It didn't on mine but makes my post pretty meaningless.
I'll try to do it in text
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 6 July 2011 15:39, e-mail mgbg25171 wrote:
> I've done it in the email body
>
eg total income = north.total + south.total
where north and south are from dimension "region" and
sales, cogs are from dimension "line item"
ie all I need the queries to do is return
On 6 Jul 2011, at 3:39pm, e-mail mgbg25171 wrote:
> A picture paints 1000 words
> Would it be ok to attach .png files of what I'm trying to do?
Please don't do that to a message on the mailing list. A picture takes a
million bits, too.
Simon.
___
Thank you for your response
I didn't quite catch what you mean't but would be happy to give examples of
the app.
A picture paints 1000 words
Would it be ok to attach .png files of what I'm trying to do?
___
sqlite-users mailing list
On Wed, Jul 06, 2011 at 01:41:13PM +0100, e-mail mgbg25171 scratched on the
wall:
> The layout where x and y are dimensions eg
> might be represented the following fact table
> xid yid data
> If I added another dimension eg yy
> might be represented by this extended fact table
> yy xid
On 06-07-2011 14:41, e-mail mgbg25171 wrote:
> The layout where x and y are dimensions eg
>
> x
> 12
>
> y 1 | 3 4
> 2 | 5 6
>
> might be represented the following fact table
>
> xid yid data
> 1 1 3
> 2 1 4
> 1 2 5
11 matches
Mail list logo