Show TOC

Function documentationKey Performance Indicators Locate this document in the navigation structure

 

Key Performance Indicators (KPIs) are a special feature that supports plant performance management applications. KPIs are numerical measures and use existing query templates or transactions to accumulate data. You can use KPIs to collect data from various sources and to calculate aggregate values on a daily, hourly, weekly, monthly basis. The aggregate values can be compared with multiple indicators.

A KPI can be a part of another KPI (Composite KPI) and can be used to calculate the value of such a Composite KPI. You can also define multiple alerts for a KPI that are triggered when specified calculated values of that KPIs reach certain thresholds.

You use the Key Performance Indicator (KPI) to do the following:

  • Create a base or composite KPI in the Object tab of the SAP MII Workbench. For more information, see Creating Key Performance Indicators.

  • Specify data providers for a KPI

  • Define maximum and minimum threshold values for KPI color range using colors Red, Yellow and Green

  • Map various columns from the datasource to create and define dimensions in the KPI

  • Map all the dimensions or delete the dimensions that are not required

Features

The KPI files are located under the default directory MIIOBJ of the SAP MII system. A Base KPI or Composite KPI can be of type, Positive, Negative or Bi-directional. Every KPI will have its own file extension type, .kpib for a base KPI, and .kpic for composite KPI.

Composite KPIs are created by selecting multiple base KPIs as the datasource using an expression evaluator on the dimensions screen. Composite KPI is a combination of transaction, query template and predefined base or composite kpi. You must add atleast one base KPI as data provider for a Composite KPI.

You use the following screens on the SAP MII Workbench to create a base or composite KPI:

  • General

    In this screen, you enter the description, data type, Unit of Measure, KPI type, target value, threshold values for color ranges, aggregation logic and custom properties (optional).

  • Data Provider

    In this screen, you enter the transaction or query template name for the base KPI which acts as the data provider for that base KPI. The data type provider is displayed in the Type field. The fields, Peristent Transaction and Log Level are displayed on selecting a transaction in the Data Provider screen. For a composite KPI, select single or multiple KPIs from the list of predefined KPIs. Additionally, you can add a query template or transaction as data provider for a composite KPI

    Note Note

    End of the note.

    You must have at least one base or composite KPI in the Data Provider screen for a composite KPI.

  • Dimensions

    In this screen, you map the attributes of the selected datasource to the existing dimensions available in the Attributes column. You can add new dimensions, change properties in the lower panel of the Dimensions screen. The dimensions must be mapped to any available datasources. The data types of added dimension and the datasource must match.

    Note Note

    • You can add a maximum of 128 dimensions.

    • The dimension Value must be mapped to any attribute of the datasource.

    End of the note.

  • Schedule/Lifecycle

    In this screen, you define the lifecycle of the data for base and composite KPI. You can define multiple tasks for an object to append, or delete the KPIs data. The available modes for KPI objects are Append and Delete.

    In Append mode, maxrowcount governs the maximum records that are fetched from the data provider and inserted in the KPI. The default count for maxrowcount is 1,20,000.

    The configuration of an KPI lifecycle is similar to MDO lifecycle except for the task modes. For more details, see MDO Lifecycle.

  • Visualization

    In this screen, you specify the display of your base or composite KPI when it is executed. KPI visualization is similar to MDO visualization. For more information, see MDO Visualization.

  • Security

    In this screen, you can authorize roles to read or write to your KPI.

  • Role mapping

    In this screen, you can authorize roles to receive the KPI notifications. Only assigned roles can access KPI values.

  • Alert Settings

    In this screen, you add or modify the alerts for the KPI. Authorized roles get notifications based on the conditions specified when an alert is raised. You select the Enable Alerts check box to raise the alerts. You can select the predefined alerts and modify the predefined values. You must define an expression in the Expression field. An alert will be raised and notifications will be sent to the authorized roles when the KPI value exceeds the alert condition as specified in the Expression field and Enable Alerts check box is selected.

    For more details, see Alerts.

  • KPI Relationship View

    This screen provides a tabular representation of the relationships between various KPIs.

    • Base KPI: The Current KPI tab displays the current KPI name and the Using KPIs tab displays the KPIs using the current KPI.

    • Composite KPI: The Current KPI tab displays the current KPI name; Using KPIs tag displays the KPIs using the current KPI; Used KPIs tab displays the list of KPIs used by the current KPI.