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.