There is also a Change Source button located at the bottom of the dialog. This
allows businesses to maintain target values in something other than the cube holding
the values for Actual. For example, the Target Values might be in a separate cube or
even an Excel spreadsheet while the Actuals are pulled from a sales cube. This can
simplify the creation of a scorecard and its KPIs by permitting the forecasting to be
performed and then stored somewhere other than the Analysis Services cube.
The final column is labeled Calculation and describes how the score for this
KPI should roll up if this KPI is an objective; in other words, if it has child KPIs.
Clicking the link in this column brings up the Calculation dialog and presents
the developer with a number of choices. These include Default, which uses the
normalized weighted average score of all child KPIs. Another choice is the average
Figure 5-14 Mapping a KPI to a measure in the data source, with optional filtering set to
members in the Customer and Product dimensions
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 103
of all the child KPIs, which takes each child??™s target and averages it to the target
for this objective. Other options include the sum of child KPIs and the minimum or
maximum value of child KPIs.
Returning to the Scorecard view in Figure 5-10 for a moment, notice that the
Target column shows both the actual value of the target and the indicator.
Pages:
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158