Adding Database Totals

You can include or exclude database totals to tailor the look of the OLAPResults section and any charts you create using the Show As Chart feature. When you activate the Database Totals feature, totals are retrieved into the OLAPResults section as additional rows or columns. In the Chart section, database totals are plotted.

The OLAPQuery section includes database totals by default. You may wish to turn off this feature if you intend to use the Drill Down feature to navigate the multidimensional cube, or if you plan to export the OLAPQuery section.

  To add database totals:

  1. Select OLAP, then OLAP Query Options and then select Database Totals in the Design section of the General tab.

  2. Click Process to add the totals to the data.

    Interactive Reporting displays the result as the first item at each level of the dimension.

    Note:

    If you enable database totals in the OLAPQuery section, totals are copied as static values into any Results section. As a result, they will not be treated as dynamically updated totals.

  To remove database totals, remove the check mark next to Database Totals on the General tab and click Process to reprocess the query.