Reports Integration Guide › Deployment › Data Warehouse › Retrospectively Enable the Data Warehouse › Configure Support for BusinessObjects Reports

Configure Support for BusinessObjects Reports

(Applies only if you want to run BusinessObjects reports for CA Data Protection.)

BusinessObjects reports for CA Data Protection show results by user and group. These reports therefore require event participant data. Before reviewers can run these reports, you must populate the Data Warehouse with this data.

To configure the Data Warehouse to support BusinessObjects reports

1. Log on to the Administration console using an account that has the 'Admin: Manage security models' privilege.
2. Click Tools, Configure Data Warehouse.

   The Configure Data Warehouse dialog displays.

3. In the General Options section, select the 'Collect event particpant data' check box.
4. (Applies only if you already use the iConsole dashboard). Resynchronize, or empty and repopulate, the Data Warehouse.

   If you already use the iConsole dashboard, your Data Warehouse already contains event and audit data. However, it does not contain event participant data. You must now add this data to the Data Warehouse. Do one of the following:

   • Go to the Advanced Options section and select the 'Resynchronize Data Warehouse data on next run' check box.

     Use this method if you have never purged events from the CMS database. Events in the CMS already correspond with events in the data warehouse. This operation is relatively fast.

   • Go to the Advanced Options section and select the 'Purge all Data Warehouse data and repopulate on next run' check box.

     Use this method if you regularly purge events from the CMS database. The Data Warehouse probably contains data for events that no longer exist in the CMS. You must eliminate this discrepancy before you run BusinessObjects reports. Specifically, you must empty and then repopulate the entire Data Warehouse so that it only contains events that currently exist in the CMS database. This operation takes longer than a resync.