Scoring type: Decreasing is Better

• Question

• 

  

  0

  Sign in to vote

  Hello,

  We have recently imported our 2007 PPS into 2010, and I have having trouble with the "Decreasing is better" scoring type. I have tried looking at these following links, but I am still having issues.

  http://social.technet.microsoft.com/Forums/en-US/ppsmonitoringandanalytics/thread/16df796a-3e03-4494-ad71-dbf0a5265ea1

  http://social.technet.microsoft.com/Forums/en-US/ppsmonitoringandanalytics/thread/678ea81f-3873-4c94-b7c2-87f89466799b

  We have imported our 2007 into 2010 PPS the goal of the KPI is this:

  1. If it goes above 99% then red indicator

  2. If it is between 95% and 99%, yellow indicator

  3. If below 95%, then green indicator.

  I have checked that everything is set to normalized (or maybe I am looking the in the wrong spot), and went based off the links above, but they all keep showing up as red indicators, in which most need to be green. My target indicator is pulled from SSAS via an MDX query (and the same with the actual), and the worst value is set to 0.

  Can anyone give me directions in where I can look to fix the problem? If you need more information, let me know. I'm trying to avoid using the "Band by stated score" banding method, which means I'll have to create custom MDX queries to handle the outcome.

  Thanks, Don

  Tuesday, February 15, 2011 8:15 PM