Search code examples
ssasdata-warehousecubemsbi

SSAS joining fact tables with different time granularity

I have two Measure Groups, one with time grain year/month(YearMonthDim), the other with time grain datetime(CalenderDim). Can I link the Month-grained fact to the CalenderDimension so I can make reports joined from both fact tables on the time dimension?

I just made a quick fix and added the YearMonthDim to the fact table with the datetime granularity. Is there another way to solve this?

Solution

  • The term I was looking for was Role Playing Dimension.

    I connected the second measure group on Month granularity with the Month attribute in the already existing CalendarDimension whose granularity is on days.

    It now works like a charm.