 Rank: Advanced Member
Groups: extranet\Forum
Joined: 8/19/2014(UTC)
Posts: 109
|
I have three different crosstabs with sales data. One with quotes, one with orders and one with invoices.
All the tables have customer id, date and amount. To separate the three different data sources I'm thinking of adding a category like "quote, order, invoice" in the tables in data modeler.
What I want to achieve is to see the full customer history cronologically in one table consisting of data from all three.
Is that possible?
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 508
|
That should be possible, I think.
Something along these lines:
- Add all three tables as individual data sources to Data Modeler.
- Use "Formats" to add an extra column to each table. The extra column can be called "Category" and should contain "Quote" for one table, "Order" for the next table and "Invoice" for the last table.
- Create a small dimension table, e.g from Excel, with the three values: Quote, Order, Invoice. Add it as a data source.
- Create a date dimension table, e.g. using Data Modeler's Date Time plugin.
- Optional: Create customer dimension table with all unique customer values. Add it as a data source.
- In a cube editor, use the three tables (formats) as fact tables - all relating to the respective dimension tables.
BR / Ole |
Ole Dyring |
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.