I tried to use following MDX query as a calculated member: "Order({[Category].[All Categories]}, [Category].[All Categories], DESC)". But I am getting following error: "Member expression 'Order({[Category].[All Categories]}, [Category].[All Categories], DESC)' must not be a set". Do you have any ideas of how could I change the query to achieve what I want?
Hi Sergey,
In case you want to create a new calculated member in "Category" dimension that returns an ordered set of members, you could try the following approach:
Aggregate( Order( [Category].[Category].Members, [Category].CurrentMember.Key, DESC ) )
Please contact support@eazybi.com if you have further questions regarding this!
Kind regards,
Martins Vanags / support@eazybi.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.