Procedure to enable the outer join in the Universe Designer

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

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.

 

1.jpg

 

 

 

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:

 

2.jpg