My Oracle Support Banner

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.