Introduction:

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.

<Please see attached file for image>

Instructions: 

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:

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

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:

<Please see attached file for image>

Release:
Component: SDBOXI