I need a calc-member that returns the name of the "top" member.
The MDX below gives me the member, but MyHierarchy has 5 levels and I want
only the name of the member at the leaf level. I tried appending
".Item(0).Name", but that gives an error.

TopCount(Descendants([MyHierarchy].CurrentMember, Level0), 1,
[Measures].[aNumber])

Thanks,
Les McPhee

You are close, technically TopCount is returning a set of tuples and
what you want is the first member within the first tuple.

TopCount(Descendants([MyHierarchy].CurrentMember, Level0), 1,
[Measures].[aNumber]).item(0).item(0).Name

Should do the trick!

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell