[Mondrian] Rank() and sets.current

Pedro Alves pmgalves at gmail.com
Tue Aug 4 11:33:23 EDT 2009


Hey everyone.

I need to do some iterations over my own set; But I can't get the 
current member to be displayed;

According to ms's docs - 
http://technet.microsoft.com/en-us/library/ms144726.aspx - the following 
query should work:


with set m as '[Markets].Children'
member [Measures].[rank] as 'm.current.Name'
select {[m]} ON COLUMNS, {[Measures].[rank]} ON ROWS
from [SteelWheelsSales]

The output here is:

  	Markets
Measures	#null	APAC	EMEA	Japan	NA
rank
		NA	NA	NA	NA	NA


I definitely expected the same name as the current set member. Is there 
a way for this to work?

Thanks



More information about the Mondrian mailing list