Proactive Supply Chain Performance Management with Predictive Analytics
Table 1
OLAP KPI structure.
Term
Definition
Goal
An MDX numeric expression that returns the target value of the KPI.
Value
An MDX numeric expression that returns the actual value of the KPI.
Status
An MDX expression that represents the state of the KPI at a specified point in time. The status MDX expression should return a normalized value between −1 and 1.
Trend
An MDX expression that evaluates the value of the KPI over time. The trend can be any time-based criterion that makes sense in a specific business context.
Status indicator
A visual element that provides a quick indication of the status for a KPI. The display of the element is determined by the value of the status MDX expression.
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 trend MDX expression.
Display folder
The folder in which the KPI will appear to the user when browsing the cube.
Parent KPI
A reference to an existing KPI that uses the value of the child KPI as part of the KPI’s computation.
Current time member
An MDX expression that returns the member that identifies the temporal context of the KPI.
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 KPI value when calculating the value of the parent KPI.