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.
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.
To create an KPI query in the SAP MII Workbench, choose
You must save the query on the Catalog tab in the appropriate project and folder.
To test the KPI query, choose