OBIEE 10g and 11g: Sub-Total and Grand Total are not Calculated in a Pivot View When the SQL Query Includes a UNION
Last updated on JANUARY 26, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.1  to 22.214.171.124.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
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