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.
Similar topics
» 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
|
|