英文:
SSAS joining fact tables with different time granularity
问题
我有两个度量组，一个使用时间粒度year/month(YearMonthDim)，另一个使用时间粒度datetime(CalenderDim)。我可以将月度粒度的事实表与CalenderDimension关联起来，以便可以制作从两个事实表连接的时间维度的报表吗？
我刚刚做了一个快速修复，将YearMonthDim添加到了带有datetime粒度的事实表中。还有其他解决方法吗？
英文:
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?
答案1
得分: 0
我正在寻找的术语是角色扮演维度。
我将第二个度量组连接到“Month”粒度，与已经存在的“CalendarDimension”中的“Month”属性连接，其粒度为天。
现在它像魔法一样运作。
英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论