cancel
Showing results for 
Search instead for 
Did you mean: 

BW OLAP Universe rank order

Former Member
0 Kudos

Hi,

I've successfully (more or less) created a rank of this kind

<expression>Rank([0CERTIFIC].CurrentMember, [0CERTIFIC].CurrentMember.Level.Members)</expression>

Now I'd like to specify the order of the rank (desc or asc by [0CERTIFIC].CurrentMember.Name).

Could you please help me?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can do a rank on a given measure like this:

<expression>Rank([0CERTIFIC].CurrentMember, ORDER( [0CERTIFIC].CurrentMember.Level.Members, [Measures][MyMeasure], BDESC)  )</expression>

Didier

Answers (1)

Answers (1)

Former Member
0 Kudos

So no way of specifying the ordering on the key of the dimension member (alphabetically ASC or DESC)?