Show TOC

Function documentationKPI Query Locate this document in the navigation structure

 

You use this function to do one of the following:

  • Select and return the data associated with a Key Performance Indicator (KPI).

  • Insert or delete the data persisted for dimensions of the KPI.

For more information about KPIs, see Key Performance Indicator Framework.

Features

A KPI query includes the following template categories:

  • Data Source

    On this screen, you select the server where the data is stored for KPI.

    You also select one of the following modes:

    • AttributeList

      Returns the list of the KPI attributes or dimensions with their associated attribute configuration

    • Delete

      Deletes persisted data

    • Insert

      Inserts data for an KPI with attributes.

    • ModeList

      Returns the available modes, in this list, for an KPI query

    • Select

      Selects and returns the data for an KPI.

    • Update

      Updates data for an KPI with its attributes. You cannot update data attributes associated with a data provider.

  • General

    For more information, see General Query Parameters.

  • Date Range

    You have to define values for Start Date and End Date. KPI values are calculated based on the values.

  • Select Query

    If you are using Select Mode, you use this screen to provide filters to your query. As you can provide value of the dimensions on which data has to be filtered. You can also specify the values for Granularity.

  • Insert Query

    If you are using Insert mode, you use this screen to configure your query.

    The attributes from the KPI are listed in the Available Attributes list.

    You can use the Filter Expression to update specific records in the persisted data.

  • Delete Query

    If you are using Delete mode, you use this screen to configure your query.

    The attributes from the KPI are listed in the Available Attributes list.

    You can use the Filter Expression to update specific records in the persisted data. If you do not provide a filter statement, all records in the data are deleted.

  • Parameters

    You use this screen to specify the value for parameters defined in the KPI query attribute values or filter statement.

    You use the Parameter Type dropdown to select the data type for the parameter. The system checks the parameter value against the selected data type.

  • Transformation

    For more information, see Transformation.

  • Security

    You use this screen to authorize roles to define a KPI Query.

Activities

To create an KPI query in the SAP MII Workbench, choose   File   New   KPIQuery.  

You must save the query on the Catalog tab in the appropriate project and folder.

To test the KPI query, choose   Tools   Test.