如何使用MDX语句计算度量值比例时,无法计算行列汇总的比例
0
MDX语句如下所示:
WITH MEMBER [Product].[ByCategory].[ColTotal] as SUM({[Product].[ByCategory].[Family]})
MEMBER [Time].[YQMD].[RowTotal] as SUM({[Time].[YQMD].[Year]})
MEMBER [Measures].[BL] as '[Measures].[Unit Sales]/([Measures].[Unit Sales],
[Time].[YQMD].CurrentMember.Parent,[Product].[ByCategory].CurrentMember.Parent)',
SOLVE_ORDER=1,FORMAT_STRING='0.00%'
Select {[Time].[YQMD].[Year].Members,[Time].[YQMD].[RowTotal]} on columns,
{[Product].[ByCategory].[Family].Members,[Product].[ByCategory].[ColTotal]} on rows
from Sales
where {[Measures].[BL]}
结果如下:
WITH MEMBER [Product].[ByCategory].[ColTotal] as SUM({[Product].[ByCategory].[Family]})
MEMBER [Time].[YQMD].[RowTotal] as SUM({[Time].[YQMD].[Year]})
MEMBER [Measures].[BL] as '[Measures].[Unit Sales]/([Measures].[Unit Sales],
[Time].[YQMD].CurrentMember.Parent,[Product].[ByCategory].CurrentMember.Parent)',
SOLVE_ORDER=1,FORMAT_STRING='0.00%'
Select {[Time].[YQMD].[Year].Members,[Time].[YQMD].[RowTotal]} on columns,
{[Product].[ByCategory].[Family].Members,[Product].[ByCategory].[ColTotal]} on rows
from Sales
where {[Measures].[BL]}
结果如下:
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
0 个回复