KPI Query

Show TOC

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.

Extension of this query is tqkp. 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. For more details, Date Range for Queries.

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 which defines data aggregation level. For example, Hour, day and so on.

When you create a base KPI, you must select Support Quarter and Minute Granularities checkbox to display aggregated data at minute and quarter levels. The options Quarter and X-minutes will appear in the Granularity field. Based on the selected granularity, the query results table displays the relevant columns as shown below:

Granularity Selection	Columns Displayed
X-Minutes	X-Minutes, Hour, Day, Week, Month, Quarter, Year
Hour	Hour, Day, Week, Month, Quarter, Year
Day	Day, Week, Month, Quarter, Year
Week	Week, Month, Quarter, Year
Month	Month, Quarter, Year
Quarter	Quarter, Year
Year	Year

Note Note

To get relevant data from KPI query, the granularity value must be less than the duration specified in Date Range.
Minute level aggregation is not supported for composite KPI.

End of the note.

The Additional Time Dimensions checkbox allows the columns to be included in the result. To include Timestamp column in the results table, you must enable Return Timestamp checkbox.

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 Start of the navigation path File Next navigation step New KPIQuery. End of the navigation path

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

To test the KPI query, choose Start of the navigation path Tools Next navigation step Test. End of the navigation path