When writing SQL queries, I prefer the JOIN clause syntax over (+) in where clause for creating table joins. It is more readable and maintainable as join logic is separated from the where clause.
BusinessObjects Universe can be configured to generate JOIN clause (ANSI92) syntax by setting a parameter in ‘Universe Parameters’ dialog available from File menu.
We get some extra benefits by using ANSI92 syntax, for instance:
Full Outer Join
The functionality to define Full Outer join is available with ANSI92 syntax only.
Advanced Join Properties
The Advanced Join Properties give additional control over the generation of SQL queries from the universe. It determines whether a conditional expression should be included in where clause or join/on clause. These options are only supported with ANSI92 syntax.
The above applies to ‘Universe Design Tool’ version 14.0.7. More at Official SAP BusinessObjects Universe Design Tool Guide.
