Snapshots and Date Dimensions
4 posters
Page 1 of 1
Snapshots and Date Dimensions
If you build weekly, monthly, quarterly, yearly, snapshot fact tables, do you also build weekly, monthly, quarterly, yearly, dimensions as well or do you use the daily date dimension and associate to the first/last day of the week, month, quarter, year?
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re:Snapshots and Date Dimensions
Hi,
I have used first/last day of the week, month, quarter, year in the dimension daily date dimension and it worked well for the reporting puropse.
thanks
I have used first/last day of the week, month, quarter, year in the dimension daily date dimension and it worked well for the reporting puropse.
thanks
hkandpal- Posts : 113
Join date : 2010-08-16
Re: Snapshots and Date Dimensions
We also use last day (i.e. snapshot date) of the week, month etc without any problem.
umutiscan- Posts : 51
Join date : 2010-11-26
Age : 44
Location : Istanbul, Turkey
Re: Snapshots and Date Dimensions
Same here, 1 dimension. I will usually add additional natural keys for specific periods (month NK, quarter NK, etc...) and populate them on the appropriate rows, leaving it null (or blank) on rows that do not apply. This stabilizes the code should the business decide to use different points in time to identify each. For example, going in they may decide to use the first day of the month, then later on decide to use the last day of the month. Such a change would only require updating the NK column in the table, rather than changing code to locate the appropriate row.
Similar topics
» Subsetting date/time Dimensions and Role Playing Date/Time Dimensions
» Daily Snapshots of all facts and Dimensions
» Adding a fact table with start date and end date to a (SSAS) multidimensional cube
» Date Columns in FACT or Dimensions
» Date Dimensions - Muliple Calendars
» Daily Snapshots of all facts and Dimensions
» Adding a fact table with start date and end date to a (SSAS) multidimensional cube
» Date Columns in FACT or Dimensions
» Date Dimensions - Muliple Calendars
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum