How to retrieve duplicate records in Web Intelligence Query (PostgreSQL DB)
Symptom
The "Retrieve duplicate rows" property is greyed in the Web Intelligence Query Panel based on Yellowbrick’s (PostgreSQL).
Environment
- SAP BusinessObjects Business Intelligence platform 4. x
- Yellowbrick’s (PostgreSQL).
Cause
The 'Retrieve Duplicate Rows' option is disabled in the Web Intelligence query panel because we are unable to retrieve duplicate entries. If a user wants to view duplicate entries for a particular query, the option below should be enabled.

Steps
- Navigate the below mentioned path.
- C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\odbc"
- Open the latest PostgreSQL driver *.prm on the BI server side.
- Change the following parameter in that .prm file from No to YES :
- <Parameter Name="DISTINCT">YES</Parameter>.
- Restart BI servers.
Conclusion: T
his blog will guide you in resolving how to enable the 'Retrieve Duplicate Rows' properties in the Web Report Query Panel, allowing you to retrieve duplicate entries in a specific query.
Feedback and comments are appreciated Thanks for stopping by, and hope this helps at least a few developers/users out there.,