OBIEE - Report-based Total

Saw Object

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
Obiee Report Based Total Table Obiee Report Based Total Pivot

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).

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.

Documentation / Reference





Discover More
Obiee 10g Aggregation Rule
OBIEE - 10G/11G - OBIPS - Aggregation Rule

Aggregation rule. The aggregation rules apply to all aggregate function used in SQL statements : The 'aggregation rule' setting in Answer is applied to sub-totals and grand totals within the Answers...
Obiee Aggregate Sum Sum Formula
OBIEE - Aggregation rules in Logical SQL with the GROUP BY and BY clause

This section outlines the rules that the BI Server follows with respect to whether or not a logical query contains a GROUP BY clause and, if a GROUP BY clause is specified, what results you should expect...
Obiee Report Based Total Table
OBIEE - Report-based Total

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. 1469404.1OBIEE...
Obiee Logical Column Level Region
OBIEE 10G/11G - Level-Based Measure Calculations

A level-based measure is a column whose values are always calculated to aspecific level of aggregation. The calculation of this measure is independent of the query grain and used always the aggregation...
Obiee11g Architecture Functional Component
OBIEE 11G - New Features and changes 11G

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is the most significant release of OBIEE since 2006. This article contains the significant changes and new features of OBIEE 11g. Oracle...



Share this page:
Follow us:
Task Runner