SAP Knowledge Base Article - Preview

3110831 - No GROUP BY clause is getting generated for MongoDB based queries in Information Design Tool.

Symptom

  • No group by clause is getting generated for MongoDB based objects in Information Design Tool.
  • When using a sum, count, min, max or Average aggregation functions in a query, no group by clause is generated.
  • No GROUP BY clause is getting generated for MongoDB based queries in Web Intelligence and running the query leads to the error below:

Error: The following database error occurred: [Simba][JSQLEngine](12290) Column AEColumnReference: "...".""."service"."SERVICE" is neither in an aggregate function nor from the GROUP BY clause.. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)

 


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.3
  • Information Design Tool
  • Web Intelligence

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

wbi, sql, script, mongo, 4.2, Launchpad , KBA , BI-BIP-IDT , Information design tool , BI-BIP-IDT-BLX , Business Layer , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.