SAP Knowledge Base Article - Preview

1937402 - Universe Generates Group By SQL Incorrectly

Symptom

  • Web Intelligence reports do not have correct group by clause. Instead of using the column names, the query has 1, 2, 3 in the group by clause.  This causes reports to fail.
  • DATABASE error: [Vertica][VJDBC](2140) ERROR: aggragates not allowed in GROUP BY Clause. (IES 10901) (Error:INF)


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform
  • Information Design Tool
  • Universe Design Tool
  • Web Intelligence

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Enterprise XI ; SAP BusinessObjects Enterprise XI 3.1

Keywords

GROUPBY Group by , column numbers , KBA , BI-BIP-SL , Semantic Layer , 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.