Platform Deployment Guide › Data Warehouse › Advanced Configuration › Retrospectively Enable the Data Warehouse

Retrospectively Enable the Data Warehouse

(Applies only if you did not enable the data warehouse when you installed the CMS.)

A data warehouse is installed automatically when you install a CMS. But if you chose not to enable the data warehouse when you installed the CMS, the data warehouse remains disabled until you manually enable it.

How To Manually Enable the Data Warehouse

Enabling the Data Warehouse requires the following steps. You must perform these steps in the order listed below. Details are provided in the following sections.

1. (Optional) Specify the Data Warehouse User database account.

   You only need this database account if you intend to run BusinessObjects reports.

2. (Optional) Specify the Unrestricted Search User database account.

   You only need this database account if you intend to run BusinessObjects reports.

3. Manually enable the data warehouse.
4. (Optional) Enable support for BusinessObjects reports:
   1. Enable the Event Participant Fact table.

      This table allows the data warehouse to collect event participant data.

   2. Resync the Event Participant Fact table or Truncate and Repopulate the Data Warehouse.

      You must perform one of the tasks. The task that you need depends on your CMS purging strategy.

More information:

Specify the Data Warehouse User

Specify the Unrestricted Search User

Manually Enable the Data Warehouse

Enable Support for BusinessObjects Reports