Hovering the mouse over Hessen displays a popup
window as shown in Figure 6-44. This pop-up displays the actual value of
$794,876.08, as well as some additional information. The first piece of information
190 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
is that Hessen represents 27% of the group. This means that of all the provinces in
Germany, Hessen accounts for 27%. Another way to look at this is that the group
percentage is the percentage of the parent; Hessen accounts for 27% of all the sales
in the parent, Germany. The next value is the percentage of the total, and that means
the percentage of the top box of the decomp tree. In this case, Hessen accounts for
3% of the grand total, or all sales. Each member shown in a decomp tree will report
the same two values: the percentage of the group and the percentage of the total. This
can be very helpful when the user is far down a decomp chain and sees a value that is
a large percentage of the group, but discovers it is but a tiny percentage of the total.
Figure 6-44 also shows that the user has clicked on Hessen and drilled down
to the City level. M??nchen is the largest city in Hessen in terms of Internet Sales
Amount and is therefore listed first. Following M??nchen are four more cities, and
then a stack representing the bottom four cities. This is the only level shown in the
figure that cannot fit all the members on a line at once, and shows what happens
Figure 6-44 A Decomposition Tree showing the path that has been followed as well as
a pop-up showing the actual values in a particular box
C h a p t e r 6 : A n a l y s i s w i t h P e r f o r m a n c e P o i n t S e r v e r a n d P r o C l a r i t y 191
when there are too many members to fit on the screen.
Pages:
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254