Issue with Grand Totals in Excel when Based on ParallelPeriod calculated member

• jmacvittie

  SSC Enthusiast

  Points: 171

  More actions

  March 9, 2009 at 11:10 am

  #202124

  Hello,

  I've created a calculated measures in an OLAP cube that show the prior year's values for another measure called "actual".

  For instance i have the following measures

  Actual

  Actual Prior

  When looking at June 2008, the Actual prior would show the Actual value for June 07

  The syntax for Actual Prior is:

  (PARALLELPERIOD([Period].[Year - Month - Date].[Year],1,[Period].[Year - Month - Date].currentmember),[Measures].[Actual])

  This works as I would expect, but when I display the data in Excel, the pivot table displays an empty grand total field for the Actual Prior field, while the values for the Actual field sum up correctly.

  Any ideas? Is there another way to achieve the same result without having to use the parallelperiod function?

• dimos.thanasoulas

  Old Hand

  Points: 326

  More actions

  February 5, 2010 at 9:03 am

  #1114526

  Check this:

  http://ssas-musings.blogspot.com/2010/01/excel-and-mdx-multiselect-problems.html

  Dimos Thanasoulas
  Business Intelligence Consultant
  Dynamic Integrated Solutions S.A
  http://www.dissoft.eu