On the other hand, the grid lacks some of the options seen on the grid
Figure 6-19 A simple Analytic Grid report being previewed by the developer before it
is published to the server. The user has expanded time but drilled down on
products.
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 161
right-click menus, so abilities such as cross drilling are gone. Therefore, realize that
charts and grids each have scenarios for which one is better than the other and can
make analysis easier for end users.
Multiple Measures
Showing multiple measures at once is one area where the grid can shine. Recall from
the previous discussion in the section on charts that showing values in the millions
compared to a small percentage forces the percentage to the right Y-axis. In a grid,
however, the data is completely valid and easy to read. As with the chart, multiple
measures cannot be placed in the background. If the developer attempts to do this,
the Dashboard Designer will automatically move the measures to the Columns panel.
This is often the desired result, however. Take Figure 6-20 as an example. In this
case, products are still on the rows and time is still on the columns. The Gross Profit
and Gross Profit Margin measures have also been added to the columns and some
expansion of data has occurred.
Figure 6-20 Gross Profit and Gross Profit margin are shown side by side, but watch out
for similarly named measures because of the width of the columns.
Pages:
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223