Mega Search
23.2 Million


Sign Up

Make a donation  
year over year growth calculation  
News Group: microsoft.public.sqlserver.olap

can any one help me for finding year over year growth calculation in mdx(ssas).
where i have data for current year(6 month) and previous year(12 month),
so can't compare current year with previous year.

i used parallel period function, but i got full year data of previous year where i want only 6 month data as compare to current year.

so, please anyone help me. i urgently want the solution. it is very important for me.   

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 10-Sep-2012, at 5:49 AM EST
From: shubh107
 
Re: year over year growth calculation  
News Group: microsoft.public.sqlserver.olap
For period over period MDX you can look at the following link...
http://stackoverflow.com/questions/9895611/how-to-create-a-period-over-period-measurement-in-mdx




On Monday, September 10, 2012 7:49:56 AM UTC-5, shubh107 wrote:
> can any one help me for finding year over year growth calculation in mdx(ssas).
> 
> where i have data for current year(6 month) and previous year(12 month),
> 
> so can't compare current year with previous year.
> 
> 
> 
> i used parallel period function, but i got full year data of previous year where i want only 6 month data as compare to current year.
> 
> 
> 
> so, please anyone help me. i urgently want the solution. it is very important for me.

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 11-Sep-2012, at 8:57 AM EST
From: m