Report Based Total in OBIEE

In this scenario column "Amount Sold by Region" is a level based measure.In the column "Amount Sold by Region", amount sold is calculated at the region level.In the below figure even though the country name is changing, the region is Europe(constant) and hence Europe will have the same "Amount Sold by Region" for different country names.

With a lowest query grain, each query that requests these column will return the amount aggregated to its associated levels (in our case by region)



To obtain the good total, you have to uncheck the aggregate option : Report-Based Total (when applicable)

How Will Report-Based Totals Created in Previous Releases Be Upgraded? 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.