Purchasing Schema Modeling

View previous topic View next topic Go down

Purchasing Schema Modeling

Post  Thulani on Mon Aug 03, 2015 9:26 am

I'm new to data warehousing. I have scenario as follows:
There is an organisation with departments. There is a list of items that departments can procure. Each department has budget for a particular item for a financial year. I have created a fact table for purchasing transactions where I have (department,item purchased, transaction date, amount and keys to my dimensions). What confuses me is the budget amount, do I have to include it in the fact table? I can see that it will be duplicated for same department purchasing same item.

I need suggestion on this schema. Thanks.

Thulani

Posts : 2
Join date : 2015-08-03

View user profile

Back to top Go down

Re: Purchasing Schema Modeling

Post  ngalemmo on Mon Aug 03, 2015 9:54 am

Budget should be in a separate fact.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Purchasing Schema Modeling

Post  Thulani on Tue Aug 04, 2015 2:48 am

Thanks a lot for the response
Just a follow up, since the budget is annual, it cannot be linked to Date dimension. Am I correct in saying that?
I think of adding financial year int the budget fact table rather than getting it from Date dimension which has DateKey as primary key.

Thulani

Posts : 2
Join date : 2015-08-03

View user profile

Back to top Go down

Re: Purchasing Schema Modeling

Post  ngalemmo on Tue Aug 04, 2015 11:51 am

Yes, you could do that provided the date dimension carries the same value. This will allow you to roll up actuals on the conformed fiscal year value.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Purchasing Schema Modeling

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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