Retrieve Duplicate Rows is disabled and unchecked in Query Panel but Query Summary shows its "ON"

Mar 07, 2017 at 03:04 PM


avatar image
Former Member

Hi All,

I'm using Web Intelligence V4.2. SP 2 (14.2.2)
I have a report developed on top of a BEx Query.

Here i want to restrict all the duplicate rows, so i opened the query properties window from the data provider and i found the option - "Retrieve Duplicate Rows" is disable for selection and is unchecked as well.

But when i check the query summary inside the report i see the value for the "Retrieve Duplicate Rows" parameter is ON. !!

Can someone explain why this option is disabled and how to enable and turn it OFF.

This can help me to restrict the duplicate rows at the very beginning of the report generation.

Thanks in advance.


10 |10000 characters needed characters left characters exceeded

Hi Arun,

Did you find any solution for this problem?



* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mar 07, 2017 at 03:06 PM

With BICS connection it's by-default disabled.it's a limitation..

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

Thanks for your information.

Is there any work around for handle this ?




can you share your webi report sample data screenshot

Skip to Content