Kimballs design Tip#51 - Time Dimension

View previous topic View next topic Go down

Kimballs design Tip#51 - Time Dimension

Post  AKris on 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

View user profile

Back to top Go down

Re: Kimballs design Tip#51 - Time Dimension

Post  gvarga on 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

View user profile

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