Show TOC

Procedure documentationSetting Up Custom Key Performance Indicators (KPIs)

 

You can set up your own custom key performance indicators (KPIs) that you want to be displayed in the SAP Supply Chain Info Center in the same way as the KPIs that SAP delivers. You can include your own business logic, and formulas for calculating the KPI values, or extend existing KPIs so that they meet your business needs better.

Prerequisites

You can define custom KPIs if the following applies:

  • You have read and write access to the following database tables:

    • sap.hba.apps.apoan.db::APOAN_CUSTOM_MEASURES

    • sap.hba.apps.apoan.db::APOAN_CUSTOM_MEASURES_TEXT

    • sap.hba.apps.apoan.db::APOAN_CUSTOM_MEASURES_PARAMS

  • You have the SAP HANA application privilege sap.hba.apps.apoan.WebContent.admin::Execute

  • You have the necessary authorizations in the SAP HANA studio. For more information, see section Authorization for SAP HANA Analytics for SAP SCM (SAP Supply Chain Info Center) of the Administrator’s Guide for SAP HANA Live for SAP Business Suite on the SAP Help Portal at http://help.sap.com/hbaInformation published on SAP site.

  • You have imported the analytic application and virtual data model content to the SAP HANA studio, and replicated the necessary master data from your SAP APO system to SAP HANA.

  • You have created a replication model in your SAP APO system, activated the replication model, and replicated planning data based on it

Procedure

You can set up a custom KPI on replication model level. This means that the definition of the custom KPI is only valid for a particular replication model. Once you have created and activated a replication model in the SAP APO system, you can configure your own custom KPIs and add them to the SAP Supply Chain Info Center.

Note Note

If you want to reactivate a deactivated replication model that contains custom KPIs, you must also redeploy the calculation views containing the custom KPIs. If the replication model was changed after deactivation, you cannot use the views containing the custom KPIs. You can choose from the following options in this case:

  • You can delete the view containing the custom KPI and create a new one

  • You can upgrade the view containing the custom KPI and redeploy it afterwards

End of the note.

To set up a custom KPI, you first set up the SAP HANA content necessary for the custom KPI in the SAP HANA studio. Then, to make the KPI available for the applications of the SAP Supply Chain Info Center, you create the KPI definition in the Create Custom KPI application. If you want to delete the KPI from the SAP Supply Chain Info Center, you can do so in Delete Custom KPI.

For more information about the procedure, and a step-by-step description of an example, see SAP Note 1880437Information published on SAP site.

Setting Up a Custom KPI in SAP HANA Studio

To set up the SAP HANA content necessary for the custom KPI, proceed as follows:

  1. In the SAP HANA studio, create a new calculation view using one of the standard, generated calculation views as a template. You can use the standard SAP HANA studio feature for copying an existing view.

    Recommendation Recommendation

    We recommend that you use one of the following views (depending on the analytic application you would like to extend with a custom KPI):

    • For the Forecast Accuracy application, use the view DemandPlanQuery (in the package sap.hba.scm-apo-go.REPLICATIONMODEL, where REPLICATIONMODEL is the name of your replication model).

    • For the Supply Projection and Stock Coverage applications, use the view SupplyNetworkPlanQuery.

    • For the Capacity Analysis application, use the views ResourceCapCnsmpnPlanQuery and ResourceConsumptionPlanQuery.

    Make sure that your custom calculation view exposes the same attributes as the views mentioned above (depending on the analytic application you would like to extend).

    End of the recommendation.

  2. Once you have created the calculation view, you add a new calculated column with column type Measure. The calculated column must have a numerical data type. In this calculated column, you define your own calculation logic.

  3. Save and activate the calculation view.

Adding a Custom KPI Definition

In the Create Custom KPI application, you make the custom KPI available for the applications of the SAP Supply Chain Info Center. In other words, you expose the calculation view you created for the custom KPI to the analytic applications.

To make the custom KPI available to the analytic applications, proceed as follows:

  1. Open the Create Custom KPI application.

    For more information about accessing the application, see Accessing the Applications.

  2. In the HANA Package field, add the full package path, for example, sap.hba.scm-apo-go.REPLICATIONMODEL, in which you have created the new calculation view.

  3. In the HANA View field, provide the name of the calculation view, for example, DPCustomKPIView1.

  4. In the View Measure field, provide the actual field name which you used in the calculation view, for example, CustomKPIMeasure. In some cases it is necessary to build separate calculation views for each periodicity (month, week, quarter, year, and so on) that a replication model supports. In such a case, use the Periodicity field to specify the periodicity a particular calculation view handles. If it is necessary to build separate calculation views for each periodicity, then you must create each of these calculation views and add each of them one by one, specifying the relevant periodicity. If the calculation view containing the custom KPI is periodicity-independent, you must select All.

  5. In the KPI Name field, enter a name for the KPI which appears in the SAP Supply Chain Info Center.

  6. Optionally, you can enter a unit of measure in the Unit of Measure field.

  7. In the Analytic Application field, specify which analytic applications a particular custom KPI calculation view should be available in.

    Note Note

    Note that KPIs cannot be valid and used in all analytic applications at the same time.

    End of the note.

  8. Optionally, in the Description of the KPI field, you can enter a description of the KPI that the system displays in the SAP Supply Chain Info Center.

Deleting an Existing Custom KPI Definition

In the Delete Custom KPI application, you can delete the custom KPIs that you previously created.

To delete the custom KPI, proceed as follows:

  1. In the Replication Model field, enter the replication model name for which you created custom KPIs. In this case, the system deletes all of the custom KPI definitions that you created for the particular replication model.

  2. In addition to the replication model, you can also specify an SAP HANA package and an SAP HANA view in the HANA Package and HANA View fields. In this case, the system deletes only the custom KPIs that you set up for the combination of these values.

  3. In the View Measure field, you can enter a concrete calculated measure name. In this case, the system only deletes the custom KPI that you set up for the specific calculated measure.