If members needs to be sorted based on some member properties, below is the example:
select non empty
order ({Hierarchize({{Descendants([Account].&[1],,LEAVES)}})}
,[Account].currentmember.properties("Label"))
on rows,
non empty CrossJoin({Hierarchize({{Descendants([Time].&[5025],,LEAVES)}})},
{Hierarchize({[Scenario].&[1],[Scenario].&[210]})}) on columns from RepCube where ([Measures].[YTD])
Database : FoodMart 2000
No comments:
Post a Comment