Re: [sqlite] multidimensional representation

2011-07-07 Thread Kit
2011/7/6 e-mail mgbg25171 : >                                1990        1991  year   <= dimension > > north         sales        10            8 >                cogs         (5)           (4) > south        sales         6             5 >                cogs      

Re: [sqlite] multidimensional representation

2011-07-07 Thread e-mail mgbg25171
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

Re: [sqlite] multidimensional representation

2011-07-06 Thread Luuk
On 06-07-2011 17:30, e-mail mgbg25171 wrote: > 19901991 year <= dimension > > north sales108 > cogs (5) (4) > southsales 6 5 > cogs (2)

Re: [sqlite] multidimensional representation

2011-07-06 Thread Roger Binns
-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

Re: [sqlite] multidimensional representation

2011-07-06 Thread e-mail mgbg25171
19901991 year <= dimension north sales108 cogs (5) (4) southsales 6 5 cogs (2) (1) regionline item <==

Re: [sqlite] multidimensional representation

2011-07-06 Thread e-mail mgbg25171
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

Re: [sqlite] multidimensional representation

2011-07-06 Thread e-mail mgbg25171
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

Re: [sqlite] multidimensional representation

2011-07-06 Thread Simon Slavin
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. ___

Re: [sqlite] multidimensional representation

2011-07-06 Thread e-mail mgbg25171
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

Re: [sqlite] multidimensional representation

2011-07-06 Thread Jay A. Kreibich
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

[sqlite] multidimensional representation

2011-07-06 Thread e-mail mgbg25171
Luuk Reading your email again...I think you've misunderstood me Each element of yy represent an instance of the WHOLE original array before the dimension was added. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] multidimensional representation

2011-07-06 Thread e-mail mgbg25171
Thanks for your response. I think your question is my point i.e. indeed...which one do you keep? It's a little ambiguous isn't it? I suppose it makes most sense to return back to the data BEFORE you added the yy dimension which result in returning to... xid yid data 1 1 3 2 1

Re: [sqlite] multidimensional representation

2011-07-06 Thread Luuk
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

[sqlite] multidimensional representation

2011-07-06 Thread e-mail mgbg25171
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 2 2 6 If I added another dimension eg yy then the following