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.