My Oracle Support Banner

OBIEE 12c: Performance Tile Is Performing 'Sum' for Resultant Union Column Which Is Set to 'Default' Aggregation (Doc ID 2524530.1)

Last updated on JANUARY 24, 2022

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.4.0 version, 

  1. In union report, aggregation rule is set to 'Default' in Edit Column Formula for a calculated resultant column but performance tile is doing summation. 
  2. It should have shown the single value but its doing summation. 
  3. While comparing the reports from 11g and 12c, could see the difference. The problem occurs only in 12c but not 11g.  

Results

The below results are from SampleAPP environment.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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