Symptom
- Incorrect SQL is generated whenever a Query filter with 'in list' operator is used.
- The 'IN' clause is missing in the SQL generated-
- Here is an example of the incorrect SQL code- Select Emp.Name from Emp where Name ('Scott')
- Issue reproducible on any WebI report based on any Oracle based universe.
Read more...
Environment
- SAP BusinessObjects Business Intelligence platform 4.0 SP09
- Web Intelligence
Product
SAP BusinessObjects Business Intelligence platform 4.0
Keywords
IN LIST, IN clause, missing, SQL, oracle.prm, incorrect SQL, query filter , 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.