1574287 - Error: "‘A database error occurred. The database error text is: [Microsoft OLE DB Provider fro SQL Server]: Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause (WIS 10901)" while refreshing migrated Webi report in BOXI 3.1

• Error: A database error occurred. The database error text is: [Microsoft OLE DB Provider fro SQL Server]: Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause (WIS 10901)
• Refreshing migrated Webi report which has an measure object
• Measure object defined with ‘CASE WHEN’ function and ‘MAX ()’ calculations in select clause for the universe.
• Parsing the measure object in the migrated universe.
• Using an Oledb connection for migrated universe based on SQL Server 2005 database.

• BusinessObjects Enterprise XI 3.1 Service Pack 2
• Microsoft SQL Server 2000
• Microsoft SQL Server 2005

KBA , BI-RA-WBI , Web Intelligence , Problem