BI Publisher Report Leaving out Duplicates

Question

When I run my query I get the full report but when I created a BIP excel report, I find that rows with a duplicate person id are missing.

This is a first time issue, is there a way around this?

Thanks.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/69670#Comment_69670

Hi @User_A_AJ,

Can you please try to get the output with RTF / PFD/ CSV using RTF template to see if it is working fine?

Just pull all the columns that you have in the query into the RTF and see if it is bringing all expected rows.#

Thank you.

Jae.L · Answer

Hi @Bhaskar Konar

Thanks for your response. I added a row in my query to filter for a person who should have 2 rows, my sql query returned 2 rows while my bi publisher report returned 1 row.

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/26612/bi-publisher-report-leaving-out-duplicates

Hi @Anna A,

If you filter your query for a specific person (who is having duplicates) and try to execute both query & the report. Do both produce same result set? Also are the numbers of columns same for both (Query & the Excel output)?

If you give some more examples like screenshots  (without sensitive data) etc. it will be helpful for the understanding.

Thank you.