Figure 6-47 shows what the first step of
the wizard would look like after the user has made their selection.
Figure 6-47 The Perspective Wizard has the ability to change selections on background
members in much the same way as the Decomposition Tree Wizard.
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 195
The second step of the wizard asks the user to select the X-axis and Y-axis
measures. In this case, Gross Profit will be placed on the Y axis and Gross Profit
Margin will be placed on the X-axis. Both of these are interesting because they can
have negative values as easily as having positive values. Figure 6-48 shows what this
first perspective chart looks like.
There are several items to discuss when looking at the Perspective Chart. First,
the dots are live, meaning that hovering the mouse over a point will create a pop-up
that shows what the dot represents (which individual product, in this case) as well
as the actual values for both measures. Second, the dots in Figure 6-48 are all the
same shape and color. This is rather boring, but beyond that, it also fails to convey as
much information as possible. This will be remedied in a moment.
Finally, there are two sliders. By default, they start out at zero, as shown here in
Figure 6-48. They can be dragged up and down or right and left. As they move, the
percentages they show change. For example, note that the slider on the right axis in
Figure 6-48 A Perspective chart with a number of data point to compare Gross Profit and
Gross Profit Margin
196 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
Figure 6-48 shows 106% and -5.
Pages:
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260