SAP Knowledge Base Article - Preview

1826060 - BI 4.0 IDT Error: missing aggregation or grouping

Symptom

In BI 4.0 Information Design Tool (IDT), the SQL being generated for a calculated attribute isn't adding the "group by" clause even though there is a sum (which requires "group by").

Error:
[] 
<com.businessobjects.dsl.commons.exception.NestedException: Failed to 
execute: 
SELECT sum(Table__3."TOTAL_AMOUNT"),  Table__3."VendorName" 
FROM 
   "_SYS_BIC"."arimaster.commonmodels/AN_INVOICE" Table__3
>


Cause of Error

SAP DBTech JDBC: [276] (at 41): missing aggregation or grouping:
TABLE__3.VendorName: line 3 col 3 (at pos 41)

There may also be another calculated attribute that is generating the "group by" correctly.


Read more...

Environment

SAP BusinessObjects Business Intelligence 4.0 Service Pack 4

HANA db 1.0 (driver 1.00.40.269667)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP HANA 1.0, platform edition

Keywords

bi 40 bi40 bi4.0 4.0 hana missing aggregation grouping error fails no group by not generate idt information design tool sql sequel , KBA , BI-BIP-UDT , Universe Design Tool , 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.