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

Kimballs design Tip#51 - Time Dimension

2 posters

Go down

Kimballs design Tip#51 - Time Dimension Empty Kimballs design Tip#51 - Time Dimension

Post  AKris Wed Dec 15, 2010 4:10 pm

This tip suggests that we can eliminate the minute dimension and have a full time stamp in the fact row.I need more clarification on how this could be implemented. For instance if I need a fact to be shown with 1/2 hour split down how could I do it without a minute dimension?Could someone help me?

AKris

Posts : 6
Join date : 2010-02-28

Back to top Go down

Kimballs design Tip#51 - Time Dimension Empty Re: Kimballs design Tip#51 - Time Dimension

Post  gvarga Wed Dec 15, 2010 5:54 pm

Concerning your business needs ( analyzing fact data in ½ hour classification ) you will however need a TIME dimension table besides the normal DATE dimension.
Your TIME table can look like

Time Id
Start Time
End Time

The table will contain 48 rows (24X2)

Of course you will connect your Fact table with that TIME dimension table and then you can analyze fact data in ½ hour classification.

gvarga

Posts : 43
Join date : 2010-12-15

Back to top Go down

Back to top

- Similar topics

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