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

• 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

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

ORA-00937, PARSE, Rank Function, GROUP BY , KBA , BI-BIP-SL , Semantic Layer , Bug Filed