SAP Knowledge Base Article - Preview

2150624 - Error: "Database error: ORA-00979: not a GROUP BY expression" when using Index Awareness

Symptom

  • The error message occurs when trying to Run Query in Web Intelligence and Information Design Tool
  • Error: Database error: ORA-00979: not a GROUP BY expression. (IES 10901)(WIS 10901)
  • In the SQL script, a "MAX" function is added to the dimensions


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.x
  • Information Design Tool
  • Oracle Database

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

GROUP BY, oracle, universe, unx, unv, IDT, UDT, Rich Client, WEBI, BI4.1, BI4.2, BI4.3, BOBJ, BOE, MAX, SQL script , KBA , BI-RA-WBI , Web Intelligence , 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.