Hi all,

I have a named set called Current Month in my SQL2005 cube. Here is the MDX
Statement to achieve it:

'Tail([Period].[fiscal].[Month].Members, 1)'



Currently my Time Dimension has dates up to 2021. How can I make my Current
Month MDX to get the last NON EMPTY Month. At the moment it gives December
2021.



Thanks for any help.


Clint