when to use a seperate month dimension?

View previous topic View next topic Go down

when to use a seperate month dimension?

Post  salaman on Mon May 16, 2011 4:29 am

Hi,

looking at various Kimball examples I notice that he often uses a seperate month dimension when there is also a day dimension that contains a month_key.

Could someone explain the value of using a seperate month dimension and if there are any specific situations in which it would be preferrable (or not) to use one?

Thanks,

Karl

salaman

Posts : 21
Join date : 2011-03-24

View user profile

Back to top Go down

Re: when to use a seperate month dimension?

Post  ngalemmo on Mon May 16, 2011 10:36 am

The primary purpose is for clarity in the model. There is no ambiguity as to the grain of the measures if the fact table uses a month dimension. It doesn't affect conformance if the attribute values in the month dimension are identical to corresponding attributes in the date dimension.

Personally, I prefer to use a single date dimension table with additional natural keys for month, quarter and year. These NK columns would usually be null except for designated rows used to represent a particular period (such as the last day of each month to represent month values). I would then use role names in the fact table to clarify the time grain (such as month_date_key). For presentation purposes, I may sometimes create views (month view, quarter view, etc...) if it helps clarify things.
avatar
ngalemmo

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

View user profile http://aginity.com

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