[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