Modify CA Business Intelligence Reports (SAP Business Objects)

This article contains the following topics:
casm1401
This article contains the following topics:
CABI 4.1 with SAP Business Objects is supported till December 31, 2018 or until the End-of-Service for
CA Service Management
- 14.1, whichever is earlier.
CA Business Intelligence JasperReports Server (CABI JasperReports Server) is now the default reporting technology for
CA Service Management
. CABI JasperReports Server is built on industry-leading TIBCO Jaspersoft technology that offers comprehensive and easy to use business intelligence capabilities like Centralized Reporting, Dashboards, and Data Analytics.
The following CA Business Intelligence (SAP BI) reports are shipped with
CA Service Management
 Release 14.1:
  • (For CA SDM) Crystal Reports and Web intelligence reports
  • (For CA Service Catalog and CA Asset Portfolio Management) Web Intelligence reports
Before you modify the reports, ensure that you have followed these prerequisites:
  • Installed Crystal Reports 2013 Designer on the machine where CA Business Intelligence Release 4.1 SP3 Client Tools are installed.
  • Completed CA Business Intelligence Configuration for CA SDM using the
    CA Service Management
     Installer.
Please do not modify OOTB Universe and Reports. Always make a copy, modify the copy and save it outside the CA Reports folder.
Modify Crystal Reports
Follow these steps:
  1. Open the Crystal Reports 2013 Designer on the machine where it is installed.
  2. Log in to the BusinessObjects Repository.
  3. Navigate to the Folder structure in the Repository Explorer and open the Target Report that you want to modify.
  4. Click Database Menu, Database Expert Edit Query.
  5. Make the necessary modifications.
  6. Create or update formulas, if required.
  7. Click File, Save As. Provide a New Report Name and save it outside of the CA Reports folder.
Modifying Web Intelligence Reports
Follow these steps:
  1. Open the Web Intelligence Rich Client on the machine where CA Business Intelligence Client Tools are installed.
  2. Log in to the BusinessObjects Repository.
  3. Navigate to the Folder structure in the Repository Explorer and open the Target Report that you want to modify
  4. Click Design, Structure.
  5. Click Data Access, Edit.
  6. Make the necessary modifications.
  7. Create or update variables, if required.
  8. Click File, Save As. Provide a New Report Name and save it outside of the CA Reports folder.
At the end of this topic, you have successfully modified the reports.