none
How to Set a KPI Indicator using "Band by Stated score" in PPS 2007 RRS feed

  • Question

  • Hi,

    I have created a Target "Forecast" Now I want to compare this value to the output provided by the MDX .

    I have used "Band by Stated Score" as set Scoring pattern and Indicator and Scoring pattern is "Increasing is Better".

    Condition for Indicator is

     If the Forecast value is bigger than Value returned by MDX then : Green

    2. If the Forecast is less than Value returned by MDX then : Yellow

    3. Otherwise: Red

     Please help how to implement this in PPS.

    Wednesday, March 31, 2010 11:23 AM

Answers

  • Hello,

    I have just completed something of the same requirement.

    Here is what you can try. In the Actual field use this MDX expression:

     

    Case

    when

    [Measures].[Forecast Value] >=  [Your MDX Value]

    Then 1

    when

    [Measures].[Forecast Value] >=  [Your MDX Value]

    then 0

    when

    [Measures].[Forecast Value] <  [Your MDX Value]

    then -1

    end

     

    In the Target select "Increasing is better" along with "Band by Numeric value of Actual".

    Set your Thresholds to 1 (Green), 0 (Yellow) and -1 (Red).

    Hope it helps.

     

    Wednesday, March 31, 2010 1:27 PM

All replies

  • Hello,

    I have just completed something of the same requirement.

    Here is what you can try. In the Actual field use this MDX expression:

     

    Case

    when

    [Measures].[Forecast Value] >=  [Your MDX Value]

    Then 1

    when

    [Measures].[Forecast Value] >=  [Your MDX Value]

    then 0

    when

    [Measures].[Forecast Value] <  [Your MDX Value]

    then -1

    end

     

    In the Target select "Increasing is better" along with "Band by Numeric value of Actual".

    Set your Thresholds to 1 (Green), 0 (Yellow) and -1 (Red).

    Hope it helps.

     

    Wednesday, March 31, 2010 1:27 PM
  • Hi Umair,

    Thanks a lot :)
    It works. I have hidden that actual column of the KPI in my Score card to implement it properly.

    Thursday, April 1, 2010 8:59 AM