After Upgrade From OBIEE 10g To 11g, Distinct Is Applied Over Sum() (Doc ID 2006631.1)

Last updated on MAY 12, 2015

Applies to:

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


After upgrading from OBIEE 10g to OBIEE or later, a report creates a SQL which has Distinct over SUM().

For example: 


In OBIEE 10g, this never happened.

Though there is a DISTINCT clause, the result of the report in OBIEE 11g is fine and there is no impact in the performance.


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