cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

-Arun

0 Kudos

Hi Arun,

Did you find any solution for this problem?

-Regards,

Satya.

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Amit,

Thanks for your information.

Is there any work around for handle this ?

Thanks

Arun

amitrathi239
Active Contributor
0 Kudos

can you share your webi report sample data screenshot

Answers (0)