SAP Knowledge Base Article - Preview

1610962 - SQL Query corrupted when Drilling Down or Enabling Scope of Analysis on a Webi Report


When a Webi report is created, the SQL query contains all the fields that are used in the report.  When the scope of Analysis option is used, or a drill-down is attempted, that causes the target field to be added to the SQL query.  If the field that is being added was not part of the original report SQL, then the resulting SQL query will be invalid and will throw either an Invalid SQL error, or a No Results error.



SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3


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