MDX 几个比率问题 原创

  

with member [Dim包月时长].[包月时长].[合计]

as 'sum([Dim包月时长].[包月时长].levels(0).members)'

 

member measures.[占比]

as

'([Dim包月时长].[包月时长],[Measures].[短信包月用户数])/

([Dim包月时长].[包月时长].[合计],[Measures].[短信包月用户数])'

,format_string = "0.0000%"

 

select {[Dim退定类型].[退定类型层次].children*{[Measures].[短信包月用户数],measures.[占比]}} on 0,

[Dim包月时长].[包月时长].children on 1

from [SMSBank]