Home Forums Data Warehousing Strategies and Ideas Multiple Calendars Using Kimball Outrigger Technique RE: Multiple Calendars Using Kimball Outrigger Technique

  • September 13, 2017 at 2:31 pm

    #1959338

    RonKyle - Wednesday, September 13, 2017 1:36 PM

    The only caution that they have is that you have to in the end restrict the join to only one row per date.  But I do that by making he calendar portion not aggregatable and setting a default.

    Are you using the CalendarName column in DimCalendar to filter the results to give the 1:1 relationship to DimDate?  I'm assuming based on Kimball's example that the DimCalendar has multiple different calendars for the same DateKey.  I haven't used this specific example with SSAS but I have used DimDate as an outrigger to other dimensions.