SAP Knowledge Base Article - Preview

1915556 - ERROR: PARSE failed: Exception DBD ORA-00937: Not a single group group function state : N/A

Symptom

  • The object was created with RANK function to have dimension in PARTITION BY and measure in ORDER BY clause
  • ERROR: PARSE failed: Exception DBD ORA-00937: Not a single group group function state : N/A
  • GROUP BY clause is missing.

  • SQL from 3.1

  • SELECT DISTINCT
    RANK() OVER (PARTITION BY (SCOTT.EMP.ENAME) ORDER BY ((count(SCOTT.EMP.EMPNO) )))
    FROM
    SCOTT.EMP
    GROUP BY
    (SCOTT.EMP.ENAME) 

  • SQL from 4.0:

    SELECT DISTINCT
    RANK() OVER (PARTITION BY (SCOTT.EMP.ENAME) ORDER BY ((count(SCOTT.EMP.EMPNO) )))
    FROM
    SCOTT.EMP


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.0 SP 06
  • Universe Design Tool
  • Oracle 11G

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

ORA-00937, PARSE, Rank Function, GROUP BY , KBA , BI-BIP-SL , Semantic Layer , 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.