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>