OBIEE 10g and 11g: Sub-Total and Grand Total are not Calculated in a Pivot View When the SQL Query Includes a UNION

(Doc ID 941888.1)

Last updated on JANUARY 26, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version [1900] to [Release 10g to 11g]
Information in this document applies to any platform.
Checked for relevance on 13-Jul-2011
Checked for relevance on 05-Nov-2013


You have a pivot view with a set of measure columns and two columns whose formulae are based on the measure: cols(like (col1 - col2)/col1).

When you have a single request (single criteria), the SubTotal/GrandTotal for the calculated column is also calculated from the column formula.

But, when you have combined requests, SubTotal/GrandTotal for the calculated column is not being calculated in the similar manner.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms