How do I get the level type meta data from a dimension/levels currentmember.
I would expect somthing like
[Periode].[YMD].currentmember(0).level.Properties("LevelType")

The reason is that I would like to have my "Full year Estimate" calculated
measure like below, instead of hard code level.ordinal or level.name

IIF(

[Periode].[YMD].currentmember(0).level.Properties("LevelType")="T imeYear",

[Measures].[Estimate],

([Measures].[Estimate],ancestor([Periode].[YMD].currentmember(0),[Periode].[YMD].[Year]))

)

Thanks for any input
Stig Torngaard, Platon

I don't think that this property is exposed through MDX, but while
looking into your question I noticed that you already have the member
name hard coded in the 'else' clause of your iif().

The other thing is that the iff statement is redundant. You could just
use the following:

([Measures].[Estimate],ancestor([Periode].[YMD].currentmember(0),
[Periode].[YMD].[Year]))


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

In article <uGA1SqibGHA.1112 (AT) TK2MSFTNGP05 (DOT) phx.gbl>, torngaard (AT) yahoo (DOT) com
says...