Cube Name: Cube
Dimensions: DimA t0 DimE (with "$" being the measure in "DimE")
Dimension to be sorted : DimC
Here's my MDX code:
Code: Select all
{
ORDER(
{TM1FILTERBYLEVEL(
{TM1SUBSETALL( [ Cube ] )}
,0)
}
,[Cube].(
[DimA].[(All Dim A)]
,[DimB].[(All Dim B)]
,[DimD].[(All Dim D)]
,[DimE].[$]
)
,[DimC] BDESC
)
}
Kenneth