Does anyone knows, if it is possible or not to write calculated member, that
makes ranking value (ranks dimension members by measures values - 1,2,3,4
and so on) for the rows in the cube? Or maybe there is another way to make
ranking for OLAP data?

Ernestas

There's a native RANK function in MDX

Rank(«Tuple», «Set»[, «Calc Expression»])


Here's an example, say you wanted to rank cities based upon Store Sales for
all time:


WITH
SET [Top Store Sales] as 'Order([customers].[city].members,[Measures].[Store
Sales],BDESC)'
member [measures].[store sales rank] as 'Rank(
[customers].CurrentMember,[Top Store Sales])'

select [customers].[city].members on rows,
{ [measures].[store sales rank] } on columns
from sales


"Ernestas" wrote: