Platform Deployment Guide › Data Warehouse › Enable the Data Warehouse at Install Time › Do I Need To Collect Event Participant Data?

Do I Need To Collect Event Participant Data?

This section summarizes the issues to consider when deciding whether to enable or disable the Event Participant Fact table in the data warehouse.

The Data Warehouse installer includes a 'Collect event participant data' check box. This check box determines whether the Event Participant Fact table is enabled or disabled. This table in the Data Warehouse associates events with participants.

If the Event Participant Fact table is enabled

This table has the potential to grow very large. Our testing indicates that the table can increase the size of the CMS database by 30-40%. The reason is because an individual event can have many participants.

However, enabling the Event Participant Fact table has one important advantage. Namely, users assigned to a Management Group security model can successfully run BusinessObjects reports for CA Data Protection.

If the Event Participant Fact table is disabled

The BusinessObjects reports for CA Data Protection do not support filtering by user or user group. In turn, the reports do not support the Management Group security model. (Under this model, reviewers can only view events where at least one participant was in their management group when the event was captured.) Therefore, if users assigned to a Management Group security model run a BusinessObjects report for CA Data Protection, the report returns zero results.

Users assigned to a Policy security model can run these reports, but they cannot filter the reports by user or user group (even if users and groups are shown as configurable report parameters).

Users who only need the iConsole dashboard (but not the BusinessObjects reports for CA Data Protection) can leave the Event Participant Fact table disabled. The dashboard does not use data in this table.

Note: If you already use the iConsole dashboard but now want to start running BusinessObjects reports for CA Data Protection, you must enable and populate the Event Participant Fact. See the reference below for details.

Can I subsequently enable or disable the Event Participant Fact table?

Yes. You can manually enable or disable the Event Participant Fact table by running wgninfra.exe commands. See the following section for details.

Note: If you want to start running BusinessObjects reports for CA Data Protection, you must enable and populate the Event Participant Fact. It is not sufficient to simply enable this table. See the reference below for details.

More information:

Enable Support for BusinessObjects Reports