Procedure to enable the outer join in the Universe Designer

Document ID : KB000033533
Last Modified Date : 14/02/2018
Show Technical Document Details


In the Universe Designer, out of the box, outer join option is grayed out shown in the below screenshot.

WARNING:  Enabling this option would slow down the performance. More rows are returned, so large amounts of data could hinder performance.  You can enable this option only if there is a report requirement to join two tables, one of which has rows that do not match those in the common column of the other table.







1. Please take a backup and edit the following file:

C:\Program Files\CA\SC\CommonReporting3\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\odbc\odbc.prm


2. Locate the following line to configure join parameters:

<Parameter Name="EXT_JOIN">NO </Parameter>


3. Modify the line to replace NO with YES as shown in the following:

<Parameter Name="EXT_JOIN">YES</Parameter>


4. Locate the following line:

<Parameter Name="OUTERJOINS_GENERATION">NO</Parameter>


5. Modify the line to replace NO with FULL_ODBC as shown in the following:



6. Add the following three lines after the OUTERJOINS_GENERATION parameter:

<Parameter Name="LEFT_OUTER"></Parameter> <Parameter Name="RIGHT_OUTER"></Parameter> <Parameter Name="OUTERJOINS_COMPLEX">Y</Parameter>


7. Save the odbc.prm file.


8. Restart the Business Objects Enterprise services.


You should now see the outer join check box enabled shown in below example: