Calculated Members - How to compare values of selected month of Year A with values of same Month of Year B

• iBar

  SSCertifiable

  Points: 5872

  More actions

  July 30, 2012 at 4:40 pm

  #151008

  HI,

  Month Over Month Comparison by Year.

  For example, I want to compare aggregated internet sales of "January 2012" with "January 2011".

  I want to choose month e.g. january and it must compare like this

  date.currentmember, parallelperiod(date.year, 1, date.month)

  I want comparison like this or vice versa.

  2005 | 2006 | 2007 | ...

  January ... | ... | ... | ...

  February ... | ... | ... | ...

  March ... | ... | ... | ...

  ...

  I want to add this as a calculated member in the cube.

  Thanks.

• iBar

  SSCertifiable

  Points: 5872

  More actions

  August 2, 2012 at 3:37 am

  #1520714

  http://stackoverflow.com/questions/5312493/in-ssas-cannot-make-the-parallelperiod-function-work-when-crossing-months-and-y

  As mentioned in this link and in the following query, its working in the desired way. How to put this in Cube as calculated member?

  SELECT

  [Date].[Month of Year].CHILDREN ON ROWS,

  ( [Date].[Calendar Year].CHILDREN, { [Measures].[Sales Amount] } ) ON COLUMNS

  FROM [Adventure Works]

  Any help please?

  Thanks.