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.