Date.Calendar on the
Columns, and Gross Profit in the Background. Clicking the Browse button opens the
report in the Browse Analytic Report viewer, and the grid is displayed. In this case,
the Big Blue Bar is gone, replaced with a single value in a cell and All Periods as the
column header and All Products as the row header.
160 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
Next to the items in the rows and columns are small buttons with a plus sign.
Clicking on that button will expand that item; in other words, it will keep that item
there but also show its children. Clicking on the plus sign next to All Periods, for
example, will keep All Periods but will also add new columns, one each for CY 2001
through CY 2004. An example of this can be seen in Figure 6-19. So far, this sounds
very similar to the Analytic Chart.
One difference, however, also shown in Figure 6-19, is that the user does not
have to expand; instead, they can drill down by double-clicking on an item. Figure
6-19 also shows the result if a user has double-clicked on All Products. Unlike the
expansion of time on the columns??”which kept All Periods on the grid??”doubleclicking
shows the children, but replaces the parents. The user is free to double-click
on any member of either the rows or columns in order to drill down.
The benefits of the grid should be immediately clear: the ability to drill down
or expand any dimension on either the rows or columns makes navigating the grid
very simple.
Pages:
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222