Skip to Content
0

[Webi 4.1] Query Stripping Error

Feb 06, 2017 at 03:50 PM

80

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Feb 06, 2017 at 04:35 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you for your quick response, Amit

Much appreciated.

Anil

0