search cancel

Procedure to enable the outer join in the Universe Designer


Article ID: 33533


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager



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>






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:


<Please see attached file for image>



Component: SDBOXI


1558699599129000033533_sktwi1f5rjvs16oqn.jpeg get_app
1558699597330000033533_sktwi1f5rjvs16oqm.jpeg get_app