[Mondrian] Re: Rank() and sets.current

[Pedro Alves]

I was able to solve my problem with this query:

with set m as '[Markets].Children'
member [Measures].[rank] as 'm.item(Rank([Markets].CurrentMember, m) - 
2).Name'
select {[m]} ON COLUMNS,
   {[Measures].[rank]} ON ROWS
from [SteelWheelsSales]


For some reason - ssas samples ;) - I was expecting Rank(m.current,m) to 
work. But I need to do Rank([Markets].CurrentMember,m)


also true that .current is not documented in mondrian docs, but I was 
expecting the same behavior.


My problem is solved, but I'm not convinced :)


Thanks


On 08/04/2009 04:33 PM, Pedro Alves wrote:
> with set m as '[Markets].Children'
> member [Measures].[rank] as 'm.current.Name'
> select {[m]} ON COLUMNS, {[Measures].[rank]} ON ROWS
> from [SteelWheelsSales]