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

Period/Time Dimension Grain

2 posters

Go down

Period/Time Dimension Grain Empty Period/Time Dimension Grain

Post  surfinwind Tue Dec 06, 2011 7:08 pm

Hi everyone!

I am in a situation with fact tables that have grain at different time period levels i. e. some daily, others monthly and some quarterly. Therefore, I am trying to determine if it is OK to use a single period dimension (with the date level grain) with all these facts? Or is it worth to have different period dimensions i. e. one for date level, one for month level, one for quarter level?

Please let me know how do you model this in your data warehouses. My current client wants to have a single period dimension (at the date level) and have it "role-play" with the facts that have grain at the higher level time periods. I'd like to recommend them an option with multiple time period dimensions, daily, weekly monthly, depending on the fact grain required ...

Essentially I am working with the forecasting data. Forecasting is done at the academic session level, not dates ... But the client has a single date dimension with all the possible periods including the academic session. However this dimension grain level is a day (or a date).

Please feel free to let me know your thoughts or share your experiences.

Thank you,
Mike

surfinwind

Posts : 6
Join date : 2009-02-03

Back to top Go down

Period/Time Dimension Grain Empty Oops

Post  surfinwind Tue Dec 06, 2011 7:17 pm

Just realized that pretty much the same question was already asked/answered here.
http://forum.kimballgroup.com/t1572-using-the-date-dimension-for-summary-fact-tables-or-new-specialized-month-dimension

Looks like it better to have a single date dimension role-play as higher level period dimensions.

Sorry about the "duplicate" post everyone.

surfinwind

Posts : 6
Join date : 2009-02-03

Back to top Go down

Period/Time Dimension Grain Empty Re: Period/Time Dimension Grain

Post  BoxesAndLines Wed Dec 07, 2011 10:40 am

Welcome to the beauty of dimensional modeling where detail facts aggregate seamlessly.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Period/Time Dimension Grain Empty Re: Period/Time Dimension Grain

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