Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Snapshots and Date Dimensions

4 posters

Go down

Snapshots and Date Dimensions Empty Snapshots and Date Dimensions

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

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

Back to top Go down

Snapshots and Date Dimensions Empty Re:Snapshots and Date Dimensions

Post  hkandpal 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

Back to top Go down

Snapshots and Date Dimensions Empty Re: Snapshots and Date Dimensions

Post  umutiscan 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 : 41
Location : Istanbul, Turkey

Back to top Go down

Snapshots and Date Dimensions Empty Re: Snapshots and Date Dimensions

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

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

http://aginity.com

Back to top Go down

Snapshots and Date Dimensions Empty Re: Snapshots and Date Dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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