Note too that totals can be
placed at either the top or bottom of the grid.
Hiding Empty Rows and Columns Notice that in Figure 6-41 there are no values for
the Customer promotion for any of the product categories or any of the years. The
Customer member still shows up because it is one of the product categories, but
seeing an empty entry like this can be confusing and can waste valuable screen
Figure 6-40 Right-clicking on different parts of a grid brings up different menus. It??™s
important to know what??™s available and where to click to get the desired options.
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 185
real estate. Some views will be very sparsely populated, containing more empty
cells than ones with values. In order to get rid of members that no values exist
for, developers can choose to hide empty rows, hide empty columns, or both. This
changes the underlying MDX query and tells it not to render any members for which
no values are returned. In the Professional client, there are two small buttons at
the right-hand side of the Rows and Columns areas of the Setup Panel.
Clicking the button next to the rows will hide any member for which all cells
in that row are empty. For example, notice in Figure 6-41 that all four years of the
Customer promotion for Accessories are blank. Clicking the button to filter out
empty rows will cause this row to disappear in the grid. However, if even a single
cell in that row had a value, the row would stay with three blank cells and one cell
with a value.
Pages:
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247