Hi:

Any one know how to determine the current level of the
given Dimensional by using MDX.

Suppose I have [Time]Dimensional that has three level
year, month, and day, and I want to create a calculated
member to determine the current level of [Time]
Dimensional and return the state as Integer.

For example,if use drill drown the [Time] Dimensional to
month, then I want to get 1.

Thanks,

Kent Kent

Something like this...

IIF(MyDim.CurrentMember.Level IS [MyLevel],
x,
y )

public @ the domain below
www.tomchester.net

"Kent Kent" <anonymous (AT) discussions (DOT) microsoft.com> wrote