How to remove duplicate lines of data in OTBI report.

Tyler Buczynski

I've written a report in order to provide aggregate data for our performance documents and their rating score. My report produces the correct data, with the exception of it producing an additional line of data for each employee. The only difference in the two lines is the calculated manager overall rating field. On one line it shows the rating score, and on the second line the field is blank. How should I remove the additional line with the blank information in the calculated manager overall rating field. Screenshot below for reference:

Shankar-Oracle

Please try the following:

1. Save your analysis with a different name (so that you do not overwrite your existing analysis as a precaution)
2. Click on the advanced tab of the respective analysis
3. Under Advanced SQL Clauses section, you would see a check box for "Distinct"
4. Check that check box and click on results

If all goes well, save your analysis (created as part of step 1) as needed.

Tyler Buczynski

Hi @Shankar-Oracle,

Thank you for your response. I tried the above steps and unfortunately it did not help. I'm still getting the same issue within the results tab.

Shankar-Oracle

Please open a new SR, by choosing reporting as your issue and OTBI custom report when further questioned (while filing the SR). Please share the SR number here, so that I can pull it into my queue for further analysis.

Mark Stoker

HI @Tyler Buczynski,

Can you share the report xml?

Thanks

Mark