SAP Knowledge Base Article - Preview

3754866 - Error: PERCENTILE_DISC() is not not a valid group by expression

Symptom

  • When using the PERCENTILE_DISC() Snowflake function in SAP BusinessObjects Information Design Tool (IDT) or Web Intelligence, users encounter a SQL compilation error: "SQL compilation error: PERCENTILE_DISC() is not a valid group by expression"
  • The generated SQL query lacks a GROUP BY clause. However, manually adding the GROUP BY statement allows the query to execute successfully.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.3
  • Web intelligence (Webi)
  • Information Design Tool (IDT)

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

webi, queries, idt, snowflake , KBA , BI-BIP-IDT-DFX , Data Foundation 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.