SAP Knowledge Base Article - Preview

3043863 - Refresh Structure Strips Outer Join (+) Syntax From SQL

Symptom

  • When migrating a unx universe using Oracle as a data source to another vendor's database, the "(+)" notation for outer joins is removed when running Refresh Structure.
  • Not all resulting SQL works correctly.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.2
  • SAP BusinessObjects Business Intelligence 4.3
  • Information Design Tool (IDT)
  • Oracle as original data source
  • non-Oracle as new data source

Product

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

Keywords

oracle outer join operator (+) missing removed deleted gone , KBA , BI-BIP-IDT , Information 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.