This report shows only
twenty four cells of data, not counting the member values in the column and row
headers. This is an extremely limited amount of data but if the query went all the
way to the day and individual customer levels, all that data would be returned for
this report even though it isn??™t needed. That particular query would be overkill
for this simple report and again, on large cubes, it could take minutes to execute.
Therefore, it??™s important to return only what is necessary for a particular report.
Adding Subtotals to a Matrix
One of the items that users may want to see on such reports is subtotals. On this
simple report there are two places to which subtotals can be added: the columns and
rows. Later reports will show that it isn??™t always this simple, because there might be
multiple levels of data from the same dimension on either rows or columns, which
can lead to multiple levels of subtotals. For now, however, it??™s enough to see how to
turn on the subtotals and apply some formatting to the subtotal cells.
In order to add subtotals, the report developer simply needs to right-click on the
cells for the row or column headers; in the case of this sample report, the cell for
Calendar_Year or the cell for Country. Right-clicking on one of these cells opens the
pop-up menu and the third item on this menu is Subtotal. Selecting Subtotal adds a
new cell below the row or to the right of the column that simply says ???Total??? and has
a green triangle in the upper right-hand corner.
Pages:
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416