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 23, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.1 [1900] to 11.1.1.9.160419 [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

Symptoms

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.

Cause

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