Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher Report Leaving out Duplicates
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.
Answers
-
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.
0 -
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.
0 -
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.
0
