Unanswered: Creating Current Month and Previous 12 Months in MS Analysis Services
Could someone please help.
I would like to use some MDX which calculates the current month for me, based on system date or some other method. That way when I report, I could use the MDX to create a calculated member (called Current Month) which I could then use. This would mean never having to manually select the current month from my time dimension.
Also, could someone please tell me how I could get a named set in Analysis Services which returned 12 different columns based on current month.
For example, if it was July, then the columns would be:
July 2003, AUg 2003, etc right through to July 2004.