DETERMINING WHICH HIERARCHY OF A DIMENSION IS SELECTED

I am trying to use MDX to dynamically determine which hierarchy of the
time dimension is selected. I have a calculated member which is using
the last non-empty descendant of the [Time].[Calendar] dimension, but
I want it to work even if Fiscal is selected instead of Calendar.
Here is the code

SUM(Tail(Filter(Descendants([Time].[Calendar].CurrentMember, [Calendar
Date]), isEmpty([Measures].[Employee Count]) = False), 1),
[Measures].[Employee Count])

What can I put in place of [Time].[Calendar].CurrentMember to take the
current hierarchy of the time dimension instead of the Calendar
hierarchy? Thanks!"Sara" <sara2thebradley@.yahoo.com> wrote in message
news:ce695524.0402030731.75f8ea41@.posting.google.c om...
> I am trying to use MDX to dynamically determine which hierarchy of the
> time dimension is selected. I have a calculated member which is using
> the last non-empty descendant of the [Time].[Calendar] dimension, but
> I want it to work even if Fiscal is selected instead of Calendar.
> Here is the code
> SUM(Tail(Filter(Descendants([Time].[Calendar].CurrentMember, [Calendar
> Date]), isEmpty([Measures].[Employee Count]) = False), 1),
> [Measures].[Employee Count])
>
> What can I put in place of [Time].[Calendar].CurrentMember to take the
> current hierarchy of the time dimension instead of the Calendar
> hierarchy? Thanks!

You'll probably get a better response by posting this in
microsoft.public.sqlserver.olap, as it's quite a specialized area.

Simon