How to get the current member in a MDX expression?

Hi, all experts here,

Thank you very much for your kind attention.

I want to know how to get the current member in a MDX expression? (e.g, we want to get the current value'2006' for the time dimension, how can we accompalish this task?)

Hope my question is clear.

With best regards,

Yours sincerely,

There is a function called CurrentMember, but you need to ask for the current member for a given hierarchy or attribute.

eg

[Date].[Calendar].CurrentMember

If you are just after the name of the current member (as in '2006') then you would do something like the following

[Date].[Calendar].CurrentMember.Name|||

Thanks a lot.

Best regards,