Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Budget Fact Table and Date Dimension Expand / Collapse
Author
Message
Posted Tuesday, November 6, 2012 12:21 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:59 PM
Points: 213, Visits: 572
We have a fact table for budgets. That table consists solely of the Budget Amount measure. How can I join it to the date dimension? The source data contains the Start Date and End Date of the budget amount. Should i use the start date, end date, both, or neither to connect my budget fact table to the date dimension?
Post #1381688
Posted Monday, November 12, 2012 9:38 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
imani_technology (11/6/2012)
We have a fact table for budgets. That table consists solely of the Budget Amount measure. How can I join it to the date dimension? The source data contains the Start Date and End Date of the budget amount. Should i use the start date, end date, both, or neither to connect my budget fact table to the date dimension?


How good is to store budges data if you can't tell the time period of such budget?

IF all budget information is annual then StartDate should suffice 'cause you can infer EndData BUT, if - at source data appears to suggest - there is a particular start/end date pair for each budgetted amount then you have to store both.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1383745
Posted Monday, November 12, 2012 12:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:59 PM
Points: 213, Visits: 572
Good point. I have modified the design accordingly.
Post #1383812
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse