SAP Knowledge Base Article - Preview

1669936 - BI 4.x Wrong SQL is generated when shortcut join is used in Information Design Tool


  • Wrong SQL is generated when  shortcut join is used in Information Design Tool.
  • In ANSI92 mode , the generated SQL in an IDT query , omits the joins in the 'FROM' clause.
  • In non ANSI92 mode, the generated SQL in an IDT query, adds the shortcut join in the 'WHERE' clause when it should not be.



  • BI 4.0 SAP BusinessObjects 4.x
  • Information Design Tool  4.x


SAP BusinessObjects Business Intelligence platform 4.0


shortcut join, SQL generation , KBA , BI-BIP-SL-DSL , Dimensional SL , Bug Filed

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.