MDX query for Getting to the same level two or three years back

• vallisaravanan

  SSC Eights!

  Points: 914

  More actions

  September 16, 2009 at 11:52 pm

  #385378

  Hi all,

  I am trying to do the CAGR calculation which may be for 2 or 3 years.I want to get to the same period two or three years back.If I am in Q1 2009 I want to get Q1 2007 or Q1 2006. If I am in Dec 2008, I would like to get Dec 2006 or Dec2005. I can even create two different calculations CAGR2 and CAGR3. But I want to go to the particular level. Is there a way to do that like the parellel period function that takes me one year back,can I be taken two or three years back to the same level?

  Thanks and Regards,

  Valli

• denglishbi

  SSCrazy Eights

  Points: 8831

  More actions

  September 17, 2009 at 11:33 am

  #1055153

  You would just change the number of periods that you want to go back from 1 to 2 or 3.

  So this would go back three years for what ever member you are currently evaluating in your hierarchy.

  ParallelPeriod ([Date].[Calendar].[Calendar Year]

  , 3

  , [Date].[Calendar].CurrentMember)

  ParallelPeriod (MDX)

  ----------------------------------------------------------------------------------------
  Dan English - http://denglishbi.wordpress.com

• vallisaravanan

  SSC Eights!

  Points: 914

  More actions

  September 18, 2009 at 1:52 am

  #1055409

  Thanks Dan, It works fine