Show TOC

Background documentationMethods of Determining Index Values for Standard KPIs Locate this document in the navigation structure

 

When you set the index values for a standard KPI, you are defining the breaking points from least desirable scores to most desirable scores.

You enter numbers from large to small or from small to large, depending on the context of the standard KPI's score. The number for the dark red color may be the lowest number in the range if exploring revenues because a low revenue is considered undesirable. Or the number for the dark red color may be the highest number in the range if exploring costs because high costs are considered undesirable.

When the Application Server administrator sets up the measures in the dimensional model that make up a KPI, the administrator chooses between one of two methods for determining the calculation for the Score measure. You must know which method was used and the range of data values that the Score measure contains so that you can set the index values correctly.

The two methods are as follows:

  • Standard method, which involves creating the measures using the actual versus target formula to determine the true score values. When assigning index values for a standard KPI using the standard method, you would enter a true range of Score values as breaking points for the Index Values.

    For example, If a KPI's score value ranges from 0 to 50, where 50 is considered exceptional and 0 is considered poor, you might enter index values of 5 (dark red), 15 (red), 30 (green), and 45 (dark green). If the standard KPI's score is 4 or below, it is colored dark red. If the KPI's score is equal to or between 5 and 14, it is colored red. If the score is equal to or between 15 and 29, it is colored yellow. If the score is equal to or between 30 and 44 it is colored green, and if the score is 45 or higher, it is colored dark green.

  • Letter Grade method, which involves creating the measures using a special formula that standardizes the Score measure. By customizing the calculation of the Score measure for each KPI, you can set the same uniform scaling for assigning index values to KPIs. The Letter Grade method applies a standard format and avoids any guesswork when it comes to determining index values. You grade acceptable and unacceptable scores by a numeric equivalent of A, B, C, D, and F grades. It is called the Letter Grade method because index values are assigned as follows:

    • Dark green box=90 (A). The KPI is colored dark green if its score is >= 90.

    • Green box=80 (B). The KPI is colored green if its score is >=80 and <=89.

    • Red box=70 (C). The KPI is colored yellow if its score is >=70 and <=79.

    • Dark red box=60 (D). The KPI is colored red if its score is >=60 and <=69.

    • Anything lower than 60 is an (F). The KPI is colored dark red if its score is <=59.

    The Score values are always 100, 90, 80, 70, 60 due to the special calculations used for the KPI measures in the dimensional model. For information, see the Server Configuration Guide for SAP BusinessObjects Strategy Management located on SAP Service Marketplace at   http://service.sap.com/instguidescpm-stm   SAP BusinessObjects Strategy Management  .