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

[rathish_s4]

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

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.,