Database Reference
In-Depth Information
(
kpivalue("Internet Sales
KPI"),
parallelperiod(
[Order
Date].[Hierarchy].[Calendar Year],
1,
[Order
Date].[Hierarchy].currentmember
)
)
) >.02
then 1
else -1
end
Note
There is no requirement that a KPI should contain all the different calcu-
lations; you can define a KPI that only contains the value and the trend or
the value and the indicator.
The calculation in this case first checks if the value for the previous period is
empty; in this case, it sets the value to
0
or neutral. The next check uses the
VBA
function called
ABS
to find the absolute value of
calculation value
- value previous year / value previous year
and checks if it is
less than or equal to
0.02
. If this is true, it sets it to
0
or neutral. If none of
these conditions are true, it checks if the value of
calculation value -
value previous year / value previous year
is above
0.02
and
then sets it to
1
or positive. In all other cases, it is specified as
-1
or negat-
ive.
11. Deploy and process the cube and test the new KPI in Excel.
Search WWH ::
Custom Search