Rank Measure

[gdimit]

Hi all,

I want to create a measure that rank the members of a dimention based on a measure.

What I came so far is to create a measure for its member in which I compare the value of the member against the value of a another member. Finally I added the new measures.
For example lets assume that I have 5 members I create 5 measures with the following rules

['Dummy1']= if ( ['Measure'] >= DB('Cube',!Dim1, DIMNM('Dim2',1), 'Measure' ), 0, 1);
['Dummy2']= if ( ['Measure'] >= DB('Cube',!Dim1, DIMNM('Dim2',2), 'Measure' ), 0, 1);
['Dummy3']= if ( ['Measure'] >= DB('Cube',!Dim1, DIMNM('Dim2',3), 'Measure' ), 0, 1);
['Dummy4']= if ( ['Measure'] >= DB('Cube',!Dim1, DIMNM('Dim2',4), 'Measure' ), 0, 1);
['Dummy5']= if ( ['Measure'] >= DB('Cube',!Dim1, DIMNM('Dim2',5), 'Measure' ), 0, 1);
['Rank'] = ['Dummy1']+['Dummy2']+['Dummy3']+['Dummy4']+['Dummy5']

The above rules gave me the result that I expect but I was wondering if is there any other more sophisticated way to write the rule?

[Wim Gielis]

Hello

Do you really expect an answer in this topic, given that in your past topics you did not bother to reply?

Wim

[gdimit]

Hi Wim,

I admit to be a bit lazy to reply but I have made only 3 posts including this one.

Now that I am replying do you have any suggestion?

Thanks in advance

[Wim Gielis]

I would use a TI process, based on an MDX subset that sorts dimension elements based on values in a cube.
I'd rather not use rules here.
Obviously, this is my guidance based on the little information you provided.

[gdimit]

Unfortunately TI process is not an option in my case.

What other information do you need to provide you in order to give me some extra tips?

[tomok]

Trying to rank measures with a rule is completely impractical for anything other than the simplest of cubes. Why even try when you can get the ranking via a report using an MDX query and the TOPCOUNT function? That's what it's for. If you had a SQL database you wouldn't calculate rank via a stored procedure or something dumb like that, you would simply query using ORDER BY.

[gdimit]

Thank for you replies.

I can fully understand that it is not the best practise to create a rank using a rule.

But my quenstion remains. If there is a more sophisticated way to right this rule.