My Oracle Support Banner

Exalytics - OBIEE 11g Report Generates Different Results and Physical Queries(SAWITH Clause) Compared To Same Report in Another Environment (Doc ID 2186856.1)

Last updated on JULY 05, 2018

Applies to:

Oracle Exalytics Software - Version 1.0.0.4.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

Symptoms

When running a report in OBIEE 11.1.1.7.150120, the report is showing different query results and different SQL in Oracle BI server query log.

For example, when running the report in the Development environment, the physical SQL is generated with a "SAWITH" clause and shows correct, expected results.

When running the same report in the Test environment, the physical SQL does not include the SAWITH clause and shows incorrect results.

NOTE: While this problem occurred on an OBIEE environment on an Exalytics server, it can occur on any OBIEE environment.

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!


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