Hi,

I have the following Time Dimension:
Fiscal (hierarchy) containing the following attributes:
Year, Quarter, Month, Day

My MDX code for current month is
Tail( Filter( [Period].[Fiscal].[Month].Members * [Measures].[Units], Not
IsEmpty([Period].CurrentMember)), 1)



The last month with data is June 2006... But my Dimension extends to 2021...
So I expect my MDX to give me the current month is June 2006... However
instead it gives me December 2021... Can anyone point out what I am doing
incorrectly?