mdx多个维度查询疑问

xiaowen_ly 2015-03-06 07:18:04



with set [custom{3D617870D704BFF0D2CC2ED4673CA5D2}] as 

nonempty([Cause].[CauseName].children,axis(0)) 

member [Measures].[MemberCount] as 

iif([Cause].[CauseName].currentmember is [Cause].[CauseName].[All],

count([custom{3D617870D704BFF0D2CC2ED4673CA5D2}]),null) 

select {{[Measures].[Metric1]},

[Measures].[MemberCount]} on 0,

{[Cause].[CauseName].[All],

subset(topcount([custom{3D617870D704BFF0D2CC2ED4673CA5D2}],10,[Measures].[Metric1]),

0,10)} on 1 

from ( select {[Cause].[CauseName].children} on 0 from 

( select {[Time].[Date].[2014-12-30]:[Time].[Date].[2015-02-19]} on 0 from DB) )

现在想在查询最终结果中添加[Cause].[CauseKey]这一维度，该怎么写呢？

...全文

388 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

liao19890923 2015-03-19

打赏
举报

如果仅仅是要添加另外一个维度的话，那你可以用CROSSJOIN把在1轴上的所有维度交叉连接起来，当然用CROSSJOIN是会影响到一定的performance问题的 with set [custom{3D617870D704BFF0D2CC2ED4673CA5D2}] as nonempty([Cause].[CauseName].children,axis(0)) member [Measures].[MemberCount] as iif([Cause].[CauseName].currentmember is [Cause].[CauseName].[All], count([custom{3D617870D704BFF0D2CC2ED4673CA5D2}]),null) select {{[Measures].[Metric1]}, [Measures].[MemberCount]} on 0, {[Cause].[CauseName].[All]* subset(topcount([custom{3D617870D704BFF0D2CC2ED4673CA5D2}],10,[Measures].[Metric1]), 0,10)*[Cause].[CauseKey].[All]} on 1 from ( select {[Cause].[CauseName].children} on 0 from ( select {[Time].[Date].[2014-12-30]:[Time].[Date].[2015-02-19]} on 0 from DB) )

xiaowen_ly 2015-03-09