SAP Knowledge Base Article - Preview

3361308 - Error: "<TABLE_NAME.COLUMN_NAME> is not a valid group by expression " running query using Snowflake LISTAGG() function in IDT

Symptom

  • SQL compilation error occurs using a LISTAGG() Snowflake function from IDT or webi
  • The error returned is: "SQL compilation error: <TABLE_NAME.COLUMN_NAME> is not a valid group by expression"
  • Editing the SQL generated and manually adding the GROUP BY statement works without errors.


is not a valid group by expression " running query using Snowflake LISTAGG() function in IDT"> Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.3
  • Web intelligence
  • Information Design Tool

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

udt, universe design tool, 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.