Handling peak time by location

[gbaren]

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.

[ngalemmo]

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.