Snapshots and Date Dimensions

View previous topic View next topic Go down

Snapshots and Date Dimensions

Post  BoxesAndLines on Thu Jun 13, 2013 11:53 am

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?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re:Snapshots and Date Dimensions

Post  hkandpal on Thu Jun 13, 2013 12:22 pm

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

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Snapshots and Date Dimensions

Post  umutiscan on Fri Jun 14, 2013 6:56 am

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 : 36
Location : Istanbul, Turkey

View user profile

Back to top Go down

Re: Snapshots and Date Dimensions

Post  ngalemmo on Fri Jun 14, 2013 2:11 pm

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

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

View user profile http://aginity.com

Back to top Go down

Re: Snapshots and Date Dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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