SAP Knowledge Base Article - Preview

1440674 - Incorrect SQL generation in Web Intelligence with unnecessary tables in the FROM clause resulting in a Cartesian Product.

Symptom

  • Incorrect SQL is generated
  • SQL shows tables included in the FROM clause which are not required
  • Result gives a Cartesian Product


Read more...

Environment

  • Business Objects Web Intelligence XI Release 2 Service Pack 5 (BO XIR2 SP5)
  • DB2 v9

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

wrong SQL, WEBI, wrong data, incorrect number of rows , 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.