Exporting data from a Web Intelligence (WEBI) Report to Comma Separate Values (CSV) format shows duplicate records in spite of configuring the report with the "Do Not Retrieve Duplicates" option.

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: