- 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)
- SAP BusinessObjects Business Intelligence 4.3
- Information Design Tool
- Web Intelligence
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 pageThis 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.