Description:
A WEBI Report can be configured to not retrieve duplicate records. This eliminates duplicate records to be shown on the report when you fetch appropriate data. WEBI report data can be exported to various formats (ex: PDF, Excel, CSV).
Although the WEBI report is configured not to retrieve duplicate records, exporting the report data to CSV format exposes the duplicate records.
Solution:
The Export to CSV option within CA Business Intelligence (CABI) runs a separate query independent of the queries used within the WEBI report. This data is sent from the WEBI cube architecture, which is directly retrieved from the database and not the WEBI report itself. This results in the CSV file containing duplicate records, which may not have existed on the main WEBI report.
This behavior is expected.
An alternative approach would be to perform an Export to Excel instead, which does not use the above CABI architecture and exports the data from the WEBI report directly.