SAP Knowledge Base Article - Preview

3534401 - Error: "Column <ColumnName> is invalid in the select list...GROUP BY clause" running a query using "SUM_OVER" function in IDT

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.