Previous Topic: Optimize TomcatNext Topic: Configure the Event Participant Fact Table


Enable Support for BusinessObjects Reports

(Only applies to CA Data Protection customers who want to run BusinessObjects reports for CA Data Protection)

BusinessObjects reports for CA Data Protection are designed to show results by user and group. These reports do require event participant data. Before reviewers can run these reports, you must populate the data warehouse with these details. Specifically, you must enable and populate the Event Participant Fact table. There are two methods for populating the Event Participant Fact table:

Resync the Event Participant Fact table

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. Specifically, you must:

  1. Manually enable the Event Participant Fact table.
  2. Run a database command to resync the Event Participant Fact table. This operation is relatively fast.
Truncate and repopulate the data warehouse

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. Specifically, you must:

  1. Manually enable the Event Participant Fact table.
  2. Run a database command to truncate and repopulate the data warehouse. This operation takes longer than a resync.

Note: If you want to use the iConsole dashboard but not run BusinessObjects reports, you do not need to populate the Event Participant Fact table. The iConsole dashboard has no dependency on the Event Participant Fact table and has no requirement for the table to be enabled.

More information:

Configure the Event Participant Fact Table

Truncate and Repopulate the Data Warehouse

Resync the Event Participant Fact Table