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

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

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