Databases Reference
In-Depth Information
TABLE 15.1
KPI
Object Properties
Name
Description
Specifies a graphical representation of a trend to provide
easy visualization of the KPI. The value of this property is a
string that maps to a bitmap.
TrendGraphic
Enables a hierarchical organization of KPIs. For example,
you could define a
Customer Scorecard
KPI to have the
children
Customer Satisfaction
and
Customer
Retention
.
ParentKpiID
Defines an MDX expression that assigns a relative impor-
tance of the current KPI to its parent.
Weight
Defines a measure group associated with this KPI, which is
used to specify dimensionality of the KPI. This property is
optional. If it is not specified, the KPI will have the dimen-
sionality of all the measure groups in the cube.
AssociatedMeasureGroupID
An MDX expression that defines the current member of the
Time
dimension that is relevant for the KPI. If this property
is not specified, the default member of the
Time
dimension
will be used.
CurrentTimeMember
Now that you know what properties the
KPI
object has, you can create a sample KPI that
enables a manager of your enterprise to monitor growth in sales. This KPI monitors the
ratio between the sales counts in the current period to those of the previous period.
To do this, you can use the MDX expression in Listing 15.1 to create the value of the KPI.
This expression calculates the ratio between the sales in the current time period and the
sales in the previous time period. Because it doesn't make sense to compare the sales for the
member
ALL
, the expression returns
NA
for the member
ALL
.
LISTING 15.1
MDX Expression for the Value of a KPI
Case
When [Time].[Time].CurrentMember.Level.Ordinal = 0 Then “NA”
When IsEmpty ( ( [Time].[Time].PrevMember,
[Measures].[Sales Count] ) ) Then Null
Else ( [Measures].[Sales Count] -
( [Time].[Time].PrevMember, [Measures].[Sales Count] ) )
/ ( [Time].[Time].PrevMember, [Measures].[Sales Count])
End
Search WWH ::
Custom Search