Database Reference
In-Depth Information
must return a value between
−
1 and 1. The KPI browser displays a red
trac light when the status is
1, a yellow trac light when the status is
0, and a green trac light when the status is 1. The MDX expression is
given next:
CASE
−
WHEN KpiValue(
''
Sales Performance
''
)/
KpiGoal(
''
Sales Performance
''
)
>
=
0.95
THEN 1
WHEN KpiValue(
''
Sales Performance
''
)/
KpiGoal(
''
Sales Performance
''
)
<
0.85
THEN -1
ELSE 0
END
In the preceding MDX expression, the
KpiValue
and the
KpiGoal
functions
retrieve, respectively, the actual value and the goal value of the
Sales
Performance
KPI.
Fig. 9.13
Graphical indicators for displaying the status of a KPI
Trend
: Here, we choose the default indicator, that is, the standard arrow.
The associated MDX expression is given next:
CASE
WHEN ( KpiValue(
''
Sales Performance
''
)-
KpiGoal(
''
Sales Performance
''
))/
KpiGoal(
''
Sales Performance
''
)
<
=-0.2
THEN -1
WHEN ( KpiValue(
''
Sales Performance
''
)-
KpiGoal(
''
Sales Performance
''
))/
KpiGoal(
''
Sales Performance
''
)
>
0.2
THEN 1
ELSE 0
END
This expression computes the trend of the KPI by subtracting current KPI
values and last year values from the same period and divided between last
year values from the same period. If there is a decrease of 20% or more,
the value of the trend is
1; if there is an increase of 20% or more, the
value of the trend is 1; otherwise, the value of the trend is 0.
Weight
: We leave it empty.
−
Search WWH ::
Custom Search