Symptom
- Below SQL compilation error occurs when running a SQL query that uses the "SUM_OVER()" function in IDT:
"Column <ColumnName> is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause" - Editing the SQL generated and manually adding the GROUP BY statement works without errors.
is invalid in the select list...GROUP BY clause" running a query using "SUM_OVER" function in IDT"> Read more...
Environment
- SAP BusinessObjects Intelligence Platform 4.x
- Web Intelligence
- Information Design Tool
Product
SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3
Keywords
4.3, 4.2, IDT, UDT, unable, wrong, exec, run, queries , KBA , BI-BIP-IDT , Information design tool , 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.