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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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