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
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.