Platform Deployment Guide › Data Warehouse › Advanced Configuration › Reconfigure the Data Warehouse

Reconfigure the Data Warehouse

You can reconfigure the Data Warehouse at any time. For example, you may want to change the settings for off-peak processing jobs or data purges.

To reconfigure the Data Warehouse

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

   General Options

   These settings enable or disable the Data Warehouse. They also specify which data gets copied into the Data Warehouse. In particular, they specify whether to include event participant data. Other settings enable regular purges of older data from the Data Warehouse.

   Important! You must collect event participant data if you intend to run BusinessObjects reports..

   Additional Population and Maintenance

   These settings configure off-peak processing jobs for the Data Warehouse.

   If purging is enabled, the purges are performed by the off-peak processing job.

   By default, these jobs run at midnight for 300 minutes, but you can reschedule them. Be aware that the data processing associated with these data warehousing jobs can generate a heavy workload on the CMS. We strongly recommend that you run these jobs during offpeak times.

   Advanced Options

   These settings configure batch sizes for data warehousing jobs. Other settings enable you to resynchronize the Data Warehouse with data in the CMS database or to purge and repopulate the entire Data Warehouse.

   Note: For details about the available settings, see the online help.