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 layo
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
>
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 4
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
http://sqlite.org:8080/cgi-bin/mailm
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 y
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
sqlite-users@sqlite.or
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.
___
sq
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 "rectangles" data cells as a
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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql
19901991 year <= dimension
north sales108
cogs (5) (4)
southsales 6 5
cogs (2) (1)
regionline item <== dime
-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
On 06-07-2011 17:30, e-mail mgbg25171 wrote:
> 19901991 year <= dimension
>
> north sales108
> cogs (5) (4)
> southsales 6 5
> cogs (2)
Dear all,
I'm able to connect to sqlite3 DB and display the data inside, but when insert
data, no matter how to try, just don't work, there's no error, but no data
inserted.
Below is the simple PDO SQL I'm using, table name is "tbl1", the two fields
name
is just "one" & "two":
$dbh = new
I don't see something like a "create table tbl1(one, two);" statement.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of James_21th
Sent: Thursday, July 07, 2011 1:52 AM
To: General Discussion of SQLite Database
Subject: [sqlite]
On Thu, Jul 7, 2011 at 7:52 AM, James_21th wrote:
> Dear all,
>
> I'm able to connect to sqlite3 DB and display the data inside, but when
> insert
> data, no matter how to try, just don't work, there's no error, but no data
> inserted.
> ...
> Any feed back will be greately appreciated!
>
See:
The table already created with some data inside, the existing data can be
display use "select * from tbl1".
- Original Message
From: Michael Stephenson
To: General Discussion of SQLite Database
Sent: Thu, 7 July, 2011 1:59:40 PM
Subject: Re: [sqlite] Insert not working for sqlite3
I
On Thu, Jul 7, 2011 at 8:24 AM, James_21th wrote:
> The table already created with some data inside, the existing data can be
> display use "select * from tbl1".
Are you 100% sure that the test.db being opened here is the same test.db
being used in the rest of he code (same directory)?
--
---
17 matches
Mail list logo