My Oracle Support Banner

Pivot Table Gives Wrong Column Sums When Data From Subject Area (Doc ID 2117766.1)

Last updated on FEBRUARY 01, 2023

Applies to:

BI Publisher (formerly XML Publisher) - Version to [Release 11.1]
Information in this document applies to any platform.


In BI Publisher

1. When a built-in Layout Editor template report with a Pivot table is run against a Subject Area the Totals do not sum up correctly.

2. When the same XPT template report is run against a Data Model using a SQL Query data set to the same data source and table
then the Pivot table Totals DO sum up correctly.

3. This issue can be replicated from OBIEE's BI Answers:

a. Under 'Columns and Measures' an 'Aggregation Rule', has the 'Report-Based Total' option as the Default - when running the Subject Area from BI Answers it generates the SAME INcorrect Totals as from BI Publisher.

b. However, from BI Answers, when CHANGING that 'Aggregation Rule' to REMOVE the 'Report-Based Total' option NOW the Pivot table output sums correctly.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.