SAP Knowledge Base Article - Preview

1908403 - BI 4.0 ERROR: column "{table}.{object}" must appear in the GROUP BY clause or be used in an aggregate function

Symptom

Web Intelligence report fails with the error:

A database error occured. The database error text is:
[DataDirect][ODBC {driver name}]
[{database}] ERROR: column
"{table}.{object}" must
appear in the GROUP BY clause or be used in an
aggregate function(File parse_agg.c;Line 404;Routine
check_ungrouped_columns_walker;).(WIS 10901)

Where {driver name}, {database}, {table}, and {object} are all replaced by names from the actual database and driver.


Read more...

Environment

SAP BusinessObjects Business Intelligence 4.0 SP7

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

bi 4.0 bi4.0 40 universe unx unv object name table schema owner webi web intelligence , 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.