SAP Knowledge Base Article - Preview

2351942 - Wrong Join In Multisource Universe SQL

Symptom

  • LEFT OUTER JOIN not generated in SQL based only on two objects from Multiple databases in Information design and Universe Design tools
  • LEFT OUTER JOIN not generated in SQL based only on two objects from Multiple databases in Information design and Universe DesignTool
  • Instead of getting LEFT JOIN, a RIGHT JOIN is generated


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.1
  • SAP BusinessObjects Business Intelligence platform 4.2
  • Information design Tool
  • Universe Design Tool
  • Oracle
  • SQL Server
  • HANA

Product

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

Keywords

left join , reversed, missed, generate, idt, udt, reverse, bi 4.1, bi 4.2 , 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.