Three years of data are shown and in each case, sales have exceeded the
target. However, if there is a desire to also see a total for the sales for all three years,
this can be achieved by dragging the Sum from the Aggregations node and dropping
it on the scorecard. Notice this is simply a sum of the values shown and could just
have easily been the average, maximum, or minimum.
Figure 5-20 Objectives can be affected by the Score Rollup Weight that can be set for
each child KPI under an objective.
112 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
Trends are a little different. First, it??™s just as easy to drag the Trend value from
the Aggregations node and drop it on the scorecard. However, exactly what is it
trending? The trend that is built into the product only looks at the previous two
columns and trends from those. In other words, the trend will look at the actual for
2002 and compare it to the actual for 2003, and do the same for the targets (although
trends for targets are often not terribly useful.)
Figure 5-22 shows what happens when the trend is added. The sum has been
removed, the trend added, and another KPI, Gross Profit Margin, has also been
added. Notice that while the Actual for sales has risen from 2002 to 2003, the Actual
for the gross profit margin has fallen slightly. The trend for Sales is up while the
trend for Gross Profit Margin is down.
Pages:
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169