Hi!

Within my cube I built a calculated member to rank the dimension [Issues].[Name Level2]. The dimension includes about 13k members in total.

The expression I used:

Rank([Issues].CurrentMember, Order({[Issues].[Name Level2].Members},[Measures].[AnzArtikel_Global], DESC)))

The problem is: This expression leads to a very slow performance on the server but also when I try to get the calculated member with MS Excel. I guess it's because the use of the order function.

The next thing I tried - I don't need all of the dimension members ranked - was the following:

Rank([Issues].CurrentMember, Head(Order({[Issues].[Name Level2].Members}, [Measures].[Anzahl Artikel], DESC) ,70)))
….without any improvements in performance.


I use MS SQL/Analysis Server 2000 and Excel as my frontend.

My question is: Is there a possibility to improve performance of the order function? Or
Is there an other way to get the same result but faster ?

Thanks a lot for any suggestion

Greatings Urs Christen