Symptom
- Web Intelligence reports do not have correct group by clause. Instead of using the column names, the query has 1, 2, 3 in the group by clause. This causes reports to fail.
- DATABASE error: [Vertica][VJDBC](2140) ERROR: aggragates not allowed in GROUP BY Clause. (IES 10901) (Error:INF)
Read more...
Environment
- SAP BusinessObjects Business Intelligence platform
- Information Design Tool
- Universe Design Tool
- Web Intelligence
Product
SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Enterprise XI ; SAP BusinessObjects Enterprise XI 3.1
Keywords
GROUPBY Group by , column numbers , 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.