Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
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.,
Labels in this area