Activating ANSI 92 Support in a Universe

To activate ANSI 92 support for joins:

1.    Select File > Parameters.
The Universe Parameters dialog box appears.

2.    Click the Parameter tab.
The Parameters page appears. It lists certain SQL generation parameters that you can set at the universe level to optimize SQL generation for the current universe. These are parameters that were included in the PRM file for the target RDBMS in previous versions of Business Objects products. Certain RDBMS specific parameters are still contained in the PRM files, but many standard SQL parameters are now listed in the Parameter page. See the chapter Setting SQL Generation Parameters for a complete list of the available parameters.

3.    Click the ANSI92 parameter in the list.

4.    Type YES in the value box.

5.    Click Replace.

6.    Click OK.
The ANSI 92 standard can now be applied to join definitions for the current universe. When you click the Advanced button on the Edit Join dialog box, the Advanced Join box appears. You can define a filter to determine which dimensions you want to include in the FROM clause for a join.