SAP Knowledge Base Article - Preview

3040458 - BI 4.x IDT: Refresh Structure Strips Outer Join (+) Syntax from SQL


When changing a universe's connection from an Oracle database to a different database, then performing a Refresh Structure action, the Oracle "Outer Join Operator" ( "(+)" ) is removed from the SQL.



  • SAP BusinessObjects Business Intelligence 4.x
  • Information Design Tool (IDT)
  • Oracle database
  • non-Oracle database


SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3


oracle outer join operator removed deleted gone missing (+) , KBA , BI-BIP-IDT , Information design tool , Problem

About this page

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

Search for additional results

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