OBIEE 11g Incorrect Figures For Calculated Measures In A Report With A UNION ('Combine with similar requests') (Doc ID 1273831.1)

Last updated on APRIL 20, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 10.1.3.4.1 [1900] to 11.1.1.9.160419
Information in this document applies to any platform.
*** Checked for Currency on 08/10/2014 ***

Symptoms

Oracle Business Intelligence (OBIEE) 10.1.3.4.x. or 11g.

Have created a request with an UNION (Combine with similar requests) of three other request.

Using a 'Pivot Table', the total value for one formula measure (formula created in the Business Model and Mapping layer, in the Administration Tool), displays incorrect figures: it displays the first value instead of adding up all of them.

Have tried the workaround of changing the aggregation method in the pivot table, but the 'Aggregation Rule' is not displayed for this formula measure with UNION. Workaround used.

In the Result tab, click on the Edit icon (pencil) for the Pivot Table.
For the formula measure, click on 'More Options' and select 'Aggregation Rule' as Sum, instead of 'Default'.
The result should be fine now.

Have also tested to modify the aggregation in the Criteria tab (see the <Note 540371.1>) but it is not changed in this UNION request.

 

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