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

when to use a seperate month dimension?

2 posters

Go down

when to use a seperate month dimension? Empty when to use a seperate month dimension?

Post  salaman Mon May 16, 2011 4:29 am


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?




Posts : 21
Join date : 2011-03-24

Back to top Go down

when to use a seperate month dimension? Empty Re: when to use a seperate month dimension?

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

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

Back to top Go down

Back to top

- Similar topics

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