Percentage over all dimension and axis

계산된 측정값 (모든 차원에 대한 비율)

CREATE MEMBER CURRENTCUBE.[MEASURES].[Sells %]
AS iif(
([Measures].[Sells],
Axis(0).Item(0).item(Axis(0).item(0).count-1).Dimension.currentmember.Parent)=0,
null,
[Measures].[Sells]/
([Measures].[Sells],Axis(0).Item(0).item(Axis(0).item(0).count-1).Dimension.currentmember.Parent) ),
FORMAT_STRING = "Percent",
VISIBLE = 1 ;