SAP Knowledge Base Article - Preview

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

Symptom

  • 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.


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

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.