A Better Date Dimension
This requirement has come up a couple of times but I have only just thought of a solution. How can your date dimension support lots of different calendars (standard January – December Gregorian, fiscal calendars starting in various months, a manufacturing calendar, etc.) without the table getting immensely wide? And how can you make the calendar in use user-selectable at report run time?