For this situation I have successfully used what I called an "annex" fact table approach.

The main fact table has its own surrogate key plus one column for each common measure...

A few suggestions:

1) Use the BIT datatype for Is* columns, which eliminates the need for a CONSTRAINT

2) Make the primary key of the calendar an INT in YYYYMMDD format (per...

Peter,

Your code is so well-written and useful. Thank you!

I would like to add a column at the end for totals and a row at the bottom for totals. Can you...