In Analysis Services, a KPI is a collection of calculations that are associated with a measure group in a cube that are used to evaluate business success. Typically, these calculations are a combination of Multidimensional Expressions (MDX) expressions or calculated members.
KPIs also have additional metadata that provides information about how client applications display the results of the KPI's calculations. The definition of a Calculation is shown by right clicking a Calculation and choosing Properties.
The following Cube KPI Definition window is shown below:
Fields | Description |
---|---|
Cube Name | A Read Only field that indicates against which OLAP Cube the KPI is defined. |
KPI Name | Specifies the name of the KPI defined in Analysis Services. |
Description | A business description of the KPI that is used to populate WhereScape RED documentation. |
Update Buttons | The Update Buttons: Update <- and Update -> are used to move from the current KPI to the previous and next KPI respectively for the current OLAP Cube. The alternative is to exit the KPI and choose the next KPI Properties screen. |
Display Folder | KPIs can be organized into user-defined folders to view and manage these attributes within the Analysis Services user interface more easily. Enter the display folder name. Note One object can be in multiple display folders, for example: |
Associated Measure Group | Specifies the Measure Group against which the KPI is defined. |
Value Expression | An MDX numeric expression that returns the actual value of the KPI. |
Goal Expression | An MDX numeric expression or a calculation that returns the target value of the KPI. |
Status Indicator | A visual element that provides a quick indication of the status of a KPI. The display of the element is determined by the value of the MDX expression that evaluates status. |
Status Expression | An MDX expression that represents the state of the KPI at a specified point in time. |
Trend Indicator | A visual element that provides a quick indication of the trend for a KPI. The display of the element is determined by the value of the MDX expression that evaluates trend. |
Trend Expression | An MDX expression that evaluates the value of the KPI over time. The trend can be any time-based criterion that is useful in a specific business context. The trend MDX expression enables a business user to determine whether the KPI is improving over time or degrading over time. |
Parent KPI | A reference to an existing KPI that uses the value of the child KPI as part of computation of the parent KPI. Sometimes, a single KPI is a computation that consists of the values for other KPIs. This property facilitates the correct display of the child KPIs underneath the parent KPI in client applications. |
Weight | An MDX numeric expression that assigns a relative importance to a KPI. If the KPI is assigned to a parent KPI, the weight is used to proportionally adjust the results of the child KPI value when calculating the value of the parent KPI. |
To View KPIs | To view the list of KPIs, right-click the OLAP Cube in the left pane and select Display KPIs. |
To Add a KPI | · To add a calculation, right-click the OLAP Cube in the left pane and select Add KPI. This can also be achieved by displaying KPIs in the middle pane, right-clicking and selecting Add KPI. Fill out the dialog box with the relevant details. |
To Delete a KPI | Display the KPIs in the middle pane, right-click the KPI and then select Delete. |