The developer must simply remember that if measures are not to be on
the rows or columns, the filter on the dashboard should not allow multiple selections
to be made.
Analytic Grids
The Analytic Grid is very similar to the Analytic Chart. The wizard asks exactly the
same questions for the grid as it does when the designer is creating a chart. Once the
design surface is loaded up, the only difference between the grid and the chart design
surface is that the grid has panels named Rows and Columns instead of Series and
Bottom Axis, respectively. This makes it very easy to understand exactly how the
data will look when the grid is laid out.
The grid has two features that the chart doesn??™t, but it also lacks many of the
features found in the chart. On the positive side, the grid allows people to drill down
on dimensions in either the rows or the columns. Technically the chart did this as
well but the user had to right-click to do it. With the grid, drilling down on multiple
dimensions is much easier. Second, the grid allows a user to either drill down (have
the children of the selection replace the selection and its siblings) or expand, which
means to show the children for the selection while leaving the parent and its siblings
visible. In fact, expanding data is more easily discoverable than drilling down, as
there is a plus sign available for expanding but the user has to know to double-click
in order to drill down.
Playing off the example used to create charts, assume that the developer creates a
new grid and places Product Model Lines on the Rows, Date.
Pages:
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221