cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate entries/rows in a BO report

0 Kudos

Hi All,

Can anyone help me by answering how to avoid duplicate entries/rows in a BO report?

Thanks Regards,

Karthick

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Karthick,

In Webi, Go to Query Panel --> Go to Query Properties and Under 'Data' Section, Uncheck "Retrieve Duplicate Rows"

You may also edit the SQL and put DISTINCT and save the query.

Hope it help

Regards,

Yuvraj Singh

Answers (4)

Answers (4)

0 Kudos

Hi All,

Thanks for your suggestions. It worked fine.

sandeepsinha327
Explorer
0 Kudos

Hi,

If you are facing this issue in a Webi report then you can go to the report which has data and then right click on the report and select Format table and in the General Tab there is an option to "Avoid duplicate row aggregation" you can check in the check box and then check the report data.

Hope this will help.

Thanks

Sandeep

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Question is quite generic.. Do you have any specific situation?. pls post it.

Thank,

Jothi

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

please search the webi 's applicationown Help files with the term "duplicate" - this will give you some good pointers .

regards,

H