Table 6-1 The Options Available to a User when Right-Clicking on a Bar in an Analytic
Report
Figure 6-9 The pop-up menu shows that bars in an Analytic Chart can do more than just
drill down.
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 149
Option Functionality
Show Only Show Only removes all other items and makes the current bar the only bar on the chart. If the four quarters
of a particular year are shown and a user right-clicks on the first quarter and chooses Show Only, quarters
two, three, and four disappear from the chart and it is redrawn with only a bar for the first quarter.
Remove Remove is the opposite of Show Only. If a user right-clicks on a bar and chooses Remove, that one bar is
removed from the graph while all others remain. This is often useful for eliminating a particularly large
or small value, or perhaps all the values listed as unknown.
Switch To
The Switch To switches the dimension on which a drill down will occur. In Figure 6-9, the
option is Switch To All Periods. Choosing this option and then drilling down on any bar will keep all the
Product Lines on the chart, but time will now drill from the All level to the Year level for each product
line. This can be seen in Figure 6-10.
Show Details Show Details will execute a Drillthrough action in the cube, often called ???drill to detail.??? Drillthrough will
pull the actual records that make up a particular value.
Pages:
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210