I need to find last working day of previous month in Calendar hierarchy for a given date - any help on this? The last day of every month is indicated by MonthEnd flag that is related to Date attribute. I need to get figures for this date in MDX query.
My Calendar dimension has Calendar hierarchy that has year, month, date levels. Also, there is a MonthEnd attribute related to date that is either yes/no.
Thanks. Pl note I cant use SSAS stored proc .
I have a solution but seems to be complex.
[Calendar].[Calendar].[Date].&} on 0
View Complete Post