KPI Sets 

Definition

A KPI set specifies all information that is required to retrieve one or more KPIs that must be made available within real-time analytical applications. KPIs may be read from queries or ODS objects in SAP BW or from analytical data stores or local KPI cache in the CRM application server.

In a BW query, a KPI can be a key figure available in columns or a characteristic (usually a navigational attribute) in rows. Variables in BW queries are not supported.

In an ODS object, a KPI could be any field in the data section. In an analytical data store, a KPI could be any non-key field.

All the KPIs in a KPI set have the same signature of key fields. Signatures may comprise of a single key field like PARTNER or PRODUCT, or a combination of dimensions, for example, PARTNER + MONTH.

In the BW queries, a key field corresponds to a characteristic available on rows. In the ODS objects and analytical data stores, the key fields correspond to table key fields (excluding the field CLIENT). You must specify the key fields of a KPI set (name, description, data type, and length) in a separate transaction.

At runtime, you must specify all the key fields to retrieve the requested KPIs.

Structure

A fully specified KPI set (maintained in the transaction Edit KPI Set) contains the following parts:

·         Header data:

o        The name of a BW query or of an ODS object

o        The BW system where this object is located

o        The name of an analytical data store

·         List of key fields mapped to the keys of the source query or ODS object or analytical data store

·        List of KPIs and their mapping to the attribute fields in the source query, the ODS object or the analytical data store

Integration

• You must specify the key fields for a KPI set like name, description, data type, and length, using the transaction Edit key field for KPI Set.                                                            
• KPI sets are referred to from within the SAP CRM Intelligence Connector.

Example

You want to retrieve the ABC class and the revenue for individual business partners and use these values to dynamically influence an interaction center script using the Intelligence Connector. Both the values are available in the data section of the ODS object in SAP BW. This ODS object has the InfoObject 0BPARTNER in the key section.

You specify a KPI set with a single key field PARTNER and two KPIs named ABC and REVENUE. Select the relevant BW system and ODS object.

At runtime, you must specify a partner number to retrieve the ABC class and revenue from the ODS object.