对于通过 SSAS 2005 MDX 的每次实施
我在计算成员中有这个 MDX 表达式,
(sum([Time Code].[Time Code Group Code],[Measures].[Event Duration])-SUM([Time Code].
[Time Code Group Code].&[MACHINE DELAY],[Measures].[Event Duration]))/(sum([Time Code].
[Time Code Group Code],[Measures].[ Event Duration]))
我想对 [时间代码] 类别为“向下”的记录执行此操作
,即
[Time Code].[Time Code Category].&[Down].
我应该如何包含此过滤器,以便仅对类别为“向下”的记录执行计算。
MDX 中是否有 FOR 每个概念。请指导我应该如何进行。
I have this MDX expression in the Calculated member
(sum([Time Code].[Time Code Group Code],[Measures].[Event Duration])-SUM([Time Code].
[Time Code Group Code].&[MACHINE DELAY],[Measures].[Event Duration]))/(sum([Time Code].
[Time Code Group Code],[Measures].[ Event Duration]))
I want to perform this operation on records who have [Time Code] category as"Down"
i.e
[Time Code].[Time Code Category].&[Down].
How should I include this filter so that the calculation is performed only on records which have Category as DOWN.
Is there FOR each concept in MDX . Please guide on how should I proceed.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
MDX 生成函数 在 MDX 中相当于每个函数。但是你不能用它来求和。在 icCube 中,您可以使用 函数 来解决这个问题,对于 ssas I 'd 使用集合:
The MDX Generate function is the equivalent in MDX of for each. However you can't use it for sum. In icCube you could use functions to solve this, for ssas I'd use sets :