Databases Reference
In-Depth Information
Figure 9-30
2. The KPI browser supports the standard slicer window at the top of
the browser. You can select specific members to narrow down the
analysis to areas of interest. For example, suppose you are interes-
ted in the sales revenue KPI for August 2003. In the slicer window,
select the Date dimension, Fiscal hierarchy, and August 2003 (found
in semester H1 FY 2004 and quarter Q1 FY 2004) as shown in
Fig-
ure 9-31
.
Figure 9-31
You will notice the KPI values have changed as shown in
Figure 9-32
,
as
have the Goals — August beats the goal!
Figure 9-32
KPIs In Depth
Every Analysis Services cube can have an associated collection of KPIs, and
each KPI has five properties as its set of metadata. These properties are
MDX expressions that return numeric values from a cube as described in the
following table.
Search WWH ::
Custom Search