Pivot Table Gives Wrong Column Sums When Data From Subject Area
Last updated on MARCH 17, 2016
Applies to:BI Publisher (formerly XML Publisher) - Version 22.214.171.124.x to 126.96.36.199.x [Release 11.1]
Information in this document applies to any platform.
In BI Publisher 188.8.131.52.5:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms