Modelling help for multiple level facts
2 posters
Page 1 of 1
Modelling help for multiple level facts
We have an Expense application which has an Expense Header, Expense Details and Expense GL Transactions.
I need some help on the design. All 3 tables contain fact and dimension data.
The issue I have is in relating the 3 fact tables.
On the Dimension side, I have created tables for Date, Customer, GL Account etc.
Do I create a Fact and Dimension table for the Expense Header and then relate the Dimension Expense Header to the Expense Details Fact.
Similarly, do I create a Fact and Dimension table foe the Expense Details and relate the Dimension Expense Details to te Expense GL Transactions Fact.
I need some help on the design. All 3 tables contain fact and dimension data.
The issue I have is in relating the 3 fact tables.
On the Dimension side, I have created tables for Date, Customer, GL Account etc.
Do I create a Fact and Dimension table for the Expense Header and then relate the Dimension Expense Header to the Expense Details Fact.
Similarly, do I create a Fact and Dimension table foe the Expense Details and relate the Dimension Expense Details to te Expense GL Transactions Fact.
terry_stjean- Posts : 1
Join date : 2009-10-23
Re: Modelling help for multiple level facts
Combine all the non-measurable attributes into an Expense Detail dimenion table and assuming that the amounts associated with the Expense Details and GL account transaction are at same level combine them into a single Fact table Expenses Fact and associate the dimension with the fact,also associate this fact table with other dimensions you have like date ,custome etc.
kapoor_dh- Posts : 24
Join date : 2009-12-08
Similar topics
» Multiple Facts or Single Facts and Status Table?
» Hierarchies with facts at every level
» Modelling, level of hierarchy, employee and organization structure
» How to model Facts with Conformed Dims on different grain level in BO XI universe
» Modelling Product Dimension when incoming fact records have missing lowest level
» Hierarchies with facts at every level
» Modelling, level of hierarchy, employee and organization structure
» How to model Facts with Conformed Dims on different grain level in BO XI universe
» Modelling Product Dimension when incoming fact records have missing lowest level
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum