How to calculate current month and next 6 months in an mdx query ?? Please help !

i want to calculate current month and n开发者_高级运维ext 6 months in an mdx query as columns..Please help !!

I have tried this within MDX, and it can be a pain. String manipulation with VBA was the most accurate way, but there are MDX-only shortcuts (that can be unreliable). See this thread, which links to another: how to get latest date in mdx?

To get current month, you can use below code:

WITH MEMBER [Measures].[Current Month] AS VBAMDX.Format(VBAMDX.Now(),"MM") SELECT {[Measures].[Current Month]} ON COLUMNS FROM [Analysis Services Tutorial];