Subtotals

The amount of memory required to calculate and store subtotals can be significant. In some cases, the size of the subtotals can surpass the size of the report result itself.

The size of the subtotals depends on the subtotaling option chosen, along with the order and the number of unique attributes. The easiest way to determine the number of subtotals being calculated is to examine the number of result rows added with the different options selected in the Advanced Subtotals Options dialog box. To access this dialog box, view the report in Developer, then point to Data, then Subtotals, and then choose Advanced. For more detailed information about the different subtotal options, see the Reports section in the Advanced Reporting Help.

Subtotals can use a great deal of memory if you select the All Subtotals option in the Pages drop-down list. This option calculates all possible subtotal calculations at runtime and stores the results in the report instance. MicroStrategy recommends that you encourage users and report designers to use less taxing options for calculating subtotals across pages, such as Selected Subtotals and Grand Total.