Key Performance Indicators, Actions, and the DRILLTHROUGH Statement - Microsoft SQL Server 2008 Analysis Services - page 259

Goal

Status

• Growth Sales
• Today - Yesterday

• Value vs Goal over
time

• Value vs Goal
Today

• Growth
• 30% a year
• 7.5% a quarter
• 2.5% a month

Value Trend

FIGURE 15.1 KPI metrics for Growth in Sales.

A KPI is a minor object defined by the Cube major object, and can be edited when the
whole cube is edited. As with most metadata objects, a KPI object has Name , ID ,
Description , Translations , DisplayFolder , and Annotations properties. Table 15.1
describes the main properties of a KPI object.

TABLE 15.1 KPI Object Properties
Name Description

Defines an MDX expression that returns the actual value of
the KPI. You can use a Value expression to specify the
total amount of sales or revenue or a ratio of growth.

Value

Defines an MDX expression that returns the goal of the
KPI, such as the percentage of satisfied customers.

Goal

Defines an MDX expression that returns a value expressing
the relation of the KPI to the goal. Status is often normal-
ized to an expression that returns a value between -1 and
1 indicating the success or failure of a KPI.

Status

Specifies a graphical representation of status to provide
easy visualization of the KPI. The value of this property is a
string that maps to a set of bitmaps.

StatusGraphic

Defines an MDX expression that returns the trend of the
KPI over time. The trend is often normalized to an expres-
sion returning values between -1 and 1 , indicating a down-
ward trend, an upward trend, or something in between.

Trend