Datacube of Datacube? [message #530646] |
Fri, 30 April 2010 12:35 |
Barrie Treloar Messages: 55 Registered: July 2009 |
Member |
|
|
I've got my transactions which I am able to create a data cube for.
I can show the sum of transactions by Category and Date (Year/Month).
What I would then like to do is to compare the current years data against the previous years. So for Category X in June 2009 vs Category X in June 2010.
I can't see how to do this.
I've exported my data cube into Excel.
Preferably I'd like to export the cube into a flat table so I can use it as a datasource for the next data cube.
Does anyone have suggestions on how to build this?
I'd love to have something dynamic so I don't have to export data I've already exported.
Something like http:// spreadsheetpage.com/index.php/tip/creating_a_database_table_ from_a_summary_table/
Cheers
Barrie
[Updated on: Fri, 30 April 2010 12:40] Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.01886 seconds