Each bar represents the total Gross Profit for each Product Line for all
time. A simple drill down will drill down on the Product Model Lines hierarchy. The
Switch To option will let the user drill down on Date.Calendar. However, what if the
user instead wants to find out which sales territories contributed to the gross margin
for a particular product line? Neither the Series nor the Bottom Axis have the Sales
Figure 6-8 A report with products in the series and time along the bottom axis. The
measure used is placed only in the background.
148 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
Option Functionality
Drill Down This is the same as simply left-clicking on the bar. It takes the user down one level in the hierarchy for
the chosen item.
Drill Down
To
This is sometimes called cross drilling because it allows the user to drill down on any dimension, not just
the dimensions currently in the Series and Bottom Axis. Cross drilling is explained in greater detail later
on in the chapter.
Drill Up Drill Up will take the current item and drill up to the previous level in the hierarchy. While drilling down
shows only the children of the chosen item, drilling up shows the parent of the chosen items and all its
siblings; in other words, it shows all items at the parent level. If the user right-clicks on the first half of 2004
and chooses to drill up, the resulting data are all the members at the Year level, not just the year 2004.
Pages:
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209