OBIEE - Report-based Total

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Presentation Service (SAW/OBIPS)

1 - About

If the Report-Based Total option is not selected, then the Oracle BI Server will calculate the total based on the entire result set, before applying any filters to the measure columns.

From OBIEE 11g: BI Design Best Practices, this option did not work in 10g and is fixed in 11g

Table view Pivot view
Advertising

3 - Function

When “Report-based total” is checked, BI Answer issues “REPORT_…” functions when subtotals are requested such as REPORT_AGGREGATE.

The REPORT_… functions must use additive measures (Not a count distinct for instance).

4 - Upgrade

In previous releases, you had the ability to create report-based totals in table views. Because report-based totals are handled slightly differently in this release, you might notice a difference in totals as follows:

  • If the previous table included all report-based totals, then all measure columns and attribute columns in the upgraded table will use the Default option with the Report-Based Total option.
  • If the previous table view included a mix of report-based totals and non-report-based totals, then all measure columns and attribute columns in the upgraded table will use the Default option with the Report-Based Total option. You can work around the upgraded totals manually. If you want to use the same measure value as in the previous release, then duplicate the measure column in the table and use the Aggregation Rule menu to specify a non-report-based total.
  • If the previous table view included all non-report-based totals, then all measure columns and attribute columns in the upgraded table will continue to use non-report-based totals.

5 - Documentation / Reference