SAP Knowledge Base Article - Preview

1819817 - BI 4 : Using percentile_disc function with group by in SQL generate the following error when being validate 'The database error text is ora-00979: not a group by expression. (wis 10901)'

Symptom

  • Cannot run WebIntelligence report with Percentile_disc and group by.
  • Validating SQL from webi report containing Percentile_disc and group by generates the following error :"A database error occurred. The database error text is ora-00979: not a
    group by expression. (wis 10901)”


Read more...

Environment

  • SAP Business Objects BI 4
  • Business Objects XI 3.1
  • WebIntelligence
  • Oracle DB

 

Product

SAP NetWeaver 7.0

Keywords

KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.