SAP Knowledge Base Article - Preview

1219697 - Changing the SQL Query GROUP BY to use integer reference instead of column name

Symptom

In BusinessObjects Enterprise XI Release 2, a Web Intelligence or Desktop Intelligence report is created from a Universe using a generic ODBC connection but the SQL query is grouped by the column name rather than the integer reference for the column name.

Current SQL:

GROUP BY

Customer.last_name

Desired SQL:

GROUP BY

1


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

GENERIC ODBC GROUPBYCOL VIEW SQL STATEMENT ODBC.PRM PRM REFERENCES INTEGERS BusinessObjects Desktop Intelligence BusinessObjects Web Intelligence or Designer Changing SQL statement for Generic ODBC driver , c2018894 , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , 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.