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

Handling peak time by location

2 posters

Go down

Handling peak time by location Empty Handling peak time by location

Post  gbaren Thu Apr 03, 2014 11:03 am

How can build the ability to report on "peak periods" into my design?

Peak periods in my application are different for each location and even different on different days. On days before a holiday, they are like Fridays, on holidays, a Saturday or Sunday, etc.

I'm considering Peak as a degenerate dimension with a Y/N assigned by ETL but can't help wondering if there is a better way.


Posts : 15
Join date : 2014-01-30
Location : 02

Back to top Go down

Handling peak time by location Empty Re: Handling peak time by location

Post  ngalemmo Thu Apr 03, 2014 12:10 pm

It depends. You could create a dimension whose natural key is location and date, but if the only attribute is the peak indicator, you are better off storing it as a degenerate dimension on the fact. If there are other attributes dependent on location and date (or expect such attributes in the future), it would be worthwhile to build a dimension table.

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