Skip to Content
avatar image
Former Member

[Webi 4.1] Query Stripping Error

Environment Details

SAP BO: 14.1.6.1785

SQL Server 2008

We have an IDT Multisource relational universe created on top of tables available in SQL server database. We have enabled “Query stripping” in Universe (Business Layer) and corresponding report query/document properties. But when we try to refresh the report, we are getting the below mentioned error.

“The following database error occurred: [Data Federator Driver] [Server] Index ‘’ in Group By list is greater than the number of Projections.”

Note: Without query stripping enabled, the same report works fine and gets refreshed without any errors.

Appreciate your help to fix this issue.

Anil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 06, 2017 at 04:35 PM

    see attached sap note.This is known issue and fixed in the BI 4.1 SP06 Patch13.

    2332301 - Wrong SQL generation when query stripping is enabled in Web Intelligence with multisource enabled unx universe

    Add comment
    10|10000 characters needed characters exceeded