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 10.1.3.4.1  to 126.96.36.199.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!