Database Reference
In-Depth Information
Year],1,[Date].[Calendar].CurrentMember)
) >.02
Then 1
Else -1
End
Note that we only have three values for status and trend: 1, -1, and 0 be-
cause we can only display upward/downward movement or no change in our
calculation.
8. Save your solution. Since KPIs are calculations, you do not have to repro-
cess any object.
9. To test the newly defined KPI, create a pivot table in Excel using the
Adven-
ture Works
cube. Navigate to the KPI's folder and check the value, goal,
status, and trend boxes next to the
Internet Order Count Growth
KPI.
Show the
Date.Calendar
hierarchy on rows, and you should see a screen
similar to the following:
Search WWH ::
Custom Search