Purchasing Schema Modeling
2 posters
Page 1 of 1
Purchasing Schema Modeling
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.
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
Re: Purchasing Schema Modeling
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.
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
Re: Purchasing Schema Modeling
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.

» Data Modeling Question (Bridge Tables?) for Star Schema for Proposals/Awards for university
» Purchasing Fact Model problem
» Start Schema vs Snow flake schema
» dim schema or DimTableName
» DWT 2nd ed insurance schema
» Purchasing Fact Model problem
» Start Schema vs Snow flake schema
» dim schema or DimTableName
» DWT 2nd ed insurance schema
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|