Finish Variance in PerformancePoint Services? RRS feed

  • Question

  • I'm stumbling my way through Performance Point (with the help of this this video from TechEd 2011  I'm trying to build a Variance dashboard that will show Cost, Work, and Finish Variance in Project Server 2010.

    I've successfully added both Cost Variance and Work Variance to my OLAP cube using the MDX expression referred to here: and have completed KPI's for both, but I can't figure out how to use the same principle to add Finish Variance.

    I've tried changing the expression used for cost and work to calculate the difference between the "Finish" and "Baseline Finish"

    iif(IsEmpty(Sum([Time].[Year].members,[Measures].[Baseline Finish])),0,iif(Sum([Time].[Year].members,[Measures].[Baseline Finish]) = 0,0,[Measures].[Finish]-[Measures].[Baseline Finish]))

    ...but it comes up with "Error" in PPS.

    I've also tried to pull in the [Finish Variance] and [ProjectFinishVariance] fields individually with no success.

    Am I over-thinking this process?  Is there an easier way to get "Finish Variance" into PerformancePoint?

    Daren Johnson

    Thursday, July 5, 2012 5:27 PM

All replies

  • Best way to troubleshoot/debug is to check the log for what the error is. And/Or

    Set SQL Profiler trace on Analysis services server, run the dashboard and verify what MDX for finish variance is being passed on to SSAS. Copy it over to SQL MDX query editor, fix and run. Anything that runs on MDX editor would run on PPS.

    Thursday, July 5, 2012 5:43 PM
  • Did you create a calculation in the cube for this or are you trying to use a calculation in the design of the KPI?  I believe you can do this right in the KPI definition with a calculation if needed, otherwise you could create a new measure in your cube and a real measure versus a calculation would be optimal if that is possible.

    Dan English's BI Blog

    Wednesday, July 11, 2012 2:20 AM