Symptom
- Incorrect SQL is getting genareted in WebI when we use an object from a creating a universe with an alias table and measure object using sum() function.
- The generated SQL contains a 'AS column__1' in SELECT clause and GROUP BY Column__1.
- This is not valid SQL and causes an error message:
"[DataDirect[ODBC PROGRESS driver][PROGRESS]Column not found/specified (7520). (WIS 10901)" - Issue is reproducible only on WebI reports based on Progress database based universe.
Read more...
Environment
- BusinessObjects XI 3.1 Service Pack 4
- Progress 10.1
Product
SAP BusinessObjects Business Intelligence platform 5.1.9
Keywords
KBA , BI-BIP-SL , Semantic Layer , 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.