Recall, however, that when creating a new
scorecard, the wizard walks the developer through to a screen that allows for the
addition of any number of KPIs at once. Technically the developer will have to click
the Add KPI button once for each new KPI, but this process is still much faster than
using the KPI button on the Create ribbon.
More importantly, if the KPIs are already created in the Analysis Services cube,
any number can be selected for inclusion at once. Figure 5-8 showed both of these
views of the wizard screen for adding new KPIs.
Therefore, one strategy for adding many KPIs at once is to simply create a new
scorecard and add the KPIs there by creating many at one time; this is often faster
than creating them one at a time using the KPI button on the Create ribbon. And,
when the new scorecard wizard is done, the new KPIs appear in the Details pane
under the KPIs folder. These KPIs can now be added to any scorecard, not just the
scorecard that created them when the wizard was run.
Figure 5-18 The scorecard now shows that bikes are 87.4% of all sales, instead of
showing the actual sales as before. This shows how adding an MDX
calculation can enhance a scorecard.
C h a p t e r 5 : M o n i t o r i n g i n P e r f o r m a n c e P o i n t S e r v e r 109
Working with Objectives
Objectives are higher level KPIs. They are usually designed to aggregate the scores
of KPIs below them. For example, a Gross Profit Margin objective might have two
KPIs below it, such as in the case of the Adventure Works cube that has both an
Internet Gross Profit Margin and a Reseller Gross Profit Margin.
Pages:
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165