Upgrade Guide › Upgrading from 14.0 › Enable BusinessObjects Reports for CA DataMinder

Enable BusinessObjects Reports for CA DataMinder

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

BusinessObjects reports for CA DataMinder 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.
3. 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.

For details about all of these tasks, see the Data Warehouse chapter of the Platform Deployment Guide.