OBIEE 11g: After Upgrading from OBIEE 11.1.1.6.12 to 11.1.1.7.140225, the BI Server Joins are Incorrect. (Doc ID 1913643.1)

Last updated on AUGUST 06, 2014

Applies to:

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

Symptoms

You have upgraded OBIEE from 11.1.1.6.12 to 11.1.1.7.140225.
Now the BI Server joins are incorrect.
BI Server joins the sub-requests using an INNER JOIN instead of a FULL OUTER JOIN.
After following the steps in <note 1605941.1> - OBIEE 11g: After Upgrade, NULL Records not Displayed Leading to Incorrect Reports, the BI Server joins the sub-requests using a LEFT OUTER JOIN.

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