Modelling help for multiple level facts

View previous topic View next topic Go down

Modelling help for multiple level facts

Post  terry_stjean on Fri Oct 23, 2009 9:32 am

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.

terry_stjean

Posts : 1
Join date : 2009-10-23

View user profile

Back to top Go down

Re: Modelling help for multiple level facts

Post  kapoor_dh on Tue Dec 08, 2009 1:30 am

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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum