Symptom
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.
Read more...
Product
SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3
Keywords
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.