SAP Knowledge Base Article - Preview

1335701 - AND operator is missing in SQL while creating Webi report in XIR2 SP5


  • ANSI parameter is set to Yes on the universe.
  • Self restricting join exist on the table used in SQL.
  • SQL generates correctly in Desktop Intelligence.
  • SQL it is missing the words “AND” in between the joins and our the self restricting joins sould be placed in the where statement. Now it is being placed in the from statement but again with no “AND” between it and the other statements.



SAP BusinessObjects Business Intelligence platform R2


ANSI92wrong SQL01212587 , KBA , BI-RA-WBI , Web Intelligence , 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.