Skip to Content
Technical Articles
Author's profile photo rathish s

How to retrieve duplicate records in Web Intelligence Query (PostgreSQL DB)

How to retrieve duplicate records in Web Intelligence Query (PostgreSQL DB)


The “Retrieve duplicate rows” property is greyed in the Web Intelligence Query Panel based on Yellowbrick’s (PostgreSQL).


  • SAP BusinessObjects Business Intelligence platform 4. x
  • Yellowbrick’s (PostgreSQL).


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.



  1. Navigate the below mentioned path.
  2. C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\odbc”
  3. Open the latest PostgreSQL driver *.prm on the BI server side.
  4. Change the following parameter in that .prm file from No to YES :
  5. <Parameter Name=”DISTINCT”>YES</Parameter>.
  6. Restart BI servers.


Conclusion:  This 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.,

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.