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

Julian Hyde jhyde at pentaho.com
Wed Aug 5 19:17:40 EDT 2009


There is a known issue with <Named Set>.Current and <Named
Set>.CurrentOrdinal. See http://jira.pentaho.com/browse/MONDRIAN-462 for
details.

Julian

> -----Original Message-----
> From: mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Pedro Alves
> Sent: Tuesday, August 04, 2009 9:04 AM
> To: Mondrian developer mailing list
> Subject: [Mondrian] Re: Rank() and sets.current
> 
> 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]
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
> 




More information about the Mondrian mailing list