SAP Knowledge Base Article - Preview

1200111 - How to Create A Left Outer Join in Universe With ANSI 92 and OUTERJOINS_GENERATION?

Symptom

In the Universe Design tool the universe parameters ANSI 92 and OUTERJOINS_GENERATION are both set to Yes. The join between two tables is defined as a left outer join, but the SQL generated returns a right outer join instead.

 


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform
  • Universe Design Tool (UDT)

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

designer,Left Outer Join , SORT_JOINS_BY_QUERY_OBJECTS, SORT JOINS BY QUERY_OBJECTS, Prioritize joins, Order joins, order of joins , KBA , BI-BIP-UDT , Universe Design Tool , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.