Figure 6-46 shows the end result of the cross-drill, in which it
Figure 6-45 The Decomposition Tree allows for easy cross-drilling, which allows users to
drill from one dimension to another.
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 193
is now shown that Jos?© has purchased three rather expensive bikes, two helmets, and
a hat. Note also that the Pareto chart is showing grid lines only for the left axis, a
change made by the developer simply to clean up the chart a bit.
There is one last item to discuss in regards to the decomp. In this case the
decomposition tree was created by launching it from the menu after resetting all
values to the defaults. Sometimes, users will want to take the current value and start
a decomposition tree at the point. Fortunately, this is simple. Right-clicking on a bar
in a graph or a cell in a grid will bring up a menu and one of the options is Analyze
in Decomposition Tree. Choosing this will create a decomposition tree with that
value at the top, and the user is free to drill and cross-drill from that point forward.
Note that whatever values were set in the chart or grid are still set in the decomp,
so if a user has right-clicked on a cell that is for just a particular month, the decomp
will only show data for that particular month regardless of which dimension the user
drills or cross-drills into.
Figure 6-46 The end result of a cross drill in which the analysis jumped from the Customer
dimension to the Product dimension
194 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
The Perspective Chart One of the advanced chart types is the Perspective Chart,
sometimes called the Perspective view or just the Perspective.
Pages:
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258