However, the first major change is that
clicking on the bar when previewing with the Browse window doesn??™t do anything.
This is because the default is to drill down on whatever is on the Series or Y-axis,
and with a measure there is nothing to which a user can drill down. At this point
there are two options. First, the user can right-click on a bar, choose Drill Down
To, locate the dimension, and then the level to which they choose to drill down.
Unfortunately, the current hierarchy on the X-axis, in this case Product Model Lines,
is grayed out in the Drill Down To list, which means this will not allow someone to
drill down to an item that is already on the report. Instead, the user can right-click on
the Big Blue Bar and choose Switch to All Products. This switches the chart so that
Figure 6-5 Drilling down on a member replaces that member and shows only its
children, as in this case where the user drilled down on the Accessory
member.
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 145
it will now drill down on the item on the X-axis (the Bottom Axis). Now, drilling
down will work as it did before.
While using the Switch to All Products allows a user to drill down on the Product
Model Lines hierarchy in this case, the display is somewhat different from the
previous chart. Figure 6-6 shows the chart with Product Model Lines on the X-axis,
Gross Profit on the Y-axis, and the user having drilled down once on the Big Blue
Bar after choosing Switch to All Products.
Pages:
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206