Similarly, the hiding empty columns means that all the cells in that
column must be blank before it will be filtered out and not appear.
Figure 6-41 Totals Options allow a user to fine tune the totals being displayed, including
when to show subtotals and when to turn them off.
186 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
It is important to note that while many people prefer to see charts and grids with
empty rows and columns filtered out, this can lead to a couple of issues. First, empty
cells still have meaning, and that meaning may range from the fact that there were no
values, to the fact that there might be a data problem. Second, the MDX statement
that filters out the empty rows or cells can, in some situations, drastically decrease
performance. This is not typical but has been seen in some cases in dealing with
large cubes (200GB or larger) or very complex cube designs. Therefore, if these
options are turned on and performance is an issue, try running the same queries
without filtering out the empty rows and columns.
Exception Highlighting Exception highlighting is one of the useful features that can
allow standard, boring cells to jump out at the user. Good and bad values can be
highlighted by changing the background colors and the font style and color so that
they are immediately obvious. Up to three conditions can be added to the grid on
which exception highlighting can be performed, but note that this is only a limit
of the Professional user interface; the underlying engine can support a virtually
unlimited number of conditions, so those wishing to perform custom programming
against the ProClarity engine are free to allow more than three conditions for
exception highlighting.
Pages:
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248