I have a period hierarchy which is set up like , Period -> All -> AllPeriod -> Then it has last 24 months (rolling) ie
Period->All->All Period ->Jul08, Aug 08, ....Jun 10. So in all it has got last 24 months in it. Now I need to create a chart in SSRS which will show data for all the years ie in this case it will have 3 series in all, one for Year 2008 (it will
contain Jul 08-Dec 08), the second series will contain data for 2009 (Jan 09-Dec 09) and the third will contain the data for year 2010 (Jan 10-Jun 10).
In my cube there are no levels like year, half year etc..all the members are in the same level. Can someone guide me to write a proper MDX for this scenario ?
What I have tried is this,
// Getting the data for 2010, I have hard coded 6 for now in the below query as I know the currentmonth is June.
[StartMonth] as '
[Measures].[SalesValue2010] as ' [Measures].[SalesValue]'
I ideally need three salesvalues on my columns .
I guess this would be easy but I am very new to MDX and as of now d
View Complete Post