Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Purchasing Schema Modeling

2 posters

Go down

Purchasing Schema Modeling Empty Purchasing Schema Modeling

Post  Thulani 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

Back to top Go down

Purchasing Schema Modeling Empty Re: Purchasing Schema Modeling

Post  ngalemmo Mon Aug 03, 2015 9:54 am

Budget should be in a separate fact.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Purchasing Schema Modeling Empty Re: Purchasing Schema Modeling

Post  Thulani 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

Back to top Go down

Purchasing Schema Modeling Empty Re: Purchasing Schema Modeling

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Purchasing Schema Modeling Empty Re: Purchasing Schema Modeling

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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