Figure 5-16 This is a scorecard showing two targets, both in the good or On Target category,
but with different scores based on how much over the target they are.
106 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
In order to set up a KPI with multiple targets, the developer clicks on the KPI in
the Workspace Browser to bring up the Summary page for the KPI. For the Actual,
the name can be changed to match the filtered value. As an example, imagine that
this KPI will present the product category of Bikes. The designer would change the
name from Actual to Bikes and then click on Data Mappings. Then a filter would
be added to filter just by bikes; this is similar to what was shown in Figure 5-14 but
would not also include the State-Province filter.
Next, the Target would have its data mapping changed to the target of just sales for
bikes. In the Adventure Works cubes there are not sales forecasts for different product
categories, so for the sake of this example a hard-coded value will be used. Again, the
designer would simply click on the Data Mappings link and choose the appropriate
value for the target. The name Target could be changed or left the same, depending on
the needs of the business. The thresholds and indicator are set as before.
Finally, the designer would click on the New Target button to add a new target
to the KPI. This target, however, will map to either the actual Sales Amount or the
Sales Amount Quota without any filters.
Pages:
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162