如何在 Microsoft Reporting Services 中编写 MDX 查询以在行上显示度量名称？
如何在 Microsoft Reporting Services 中编写 MDX 查询，以显示事实表中的某些度量名称以及与该度量关联的总度量（金额）？并且度量名称应位于行上。例如，事实表具有如下度量；
FK FK2 Measure AA Measure BB
1 4 60 89
2 4 15 78
MDX 查询应显示
Measure AA 149
Measure BB 93
How can I get this??
How can I write an MDX query in Microsoft Reporting Services that displays some measures names in the fact table and total measures (amount) associated to that measure?, and measure names should be on the rows. For example, a fact table has measures as follows;
FK FK2 Measure AA Measure BB
1 4 60 89
2 4 15 78
The MDX query should display
Measure AA 149
Measure BB 93
How can I achieve this??
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这是 Reporting Services 的已知限制；您必须使用一种解决方法，即使用 MDX 查询作为表达式。
This is a known limitation of Reporting Services; you have to use a workaround, which is to use the MDX query as an expression.