Previous Topic: Manually Enable the Data WarehouseNext Topic: Do I Need To Collect Event Participant Data?


Enable the Event Participant Fact Table

The Event Participant Fact table in the Data Warehouse associates events with participants. When you enable this table, event participant data gets stored in the Data Warehouse.

You manually enable the Event Participant Fact table by running a wgninfra.exe command. You can also manually disable this table.

Enable the Event Participant Fact table

From a command prompt in the \system subfolder of the CA DLP installation folder on the CMS, run the following command:

wgninfra -localexec wigan/schema/Schema RunScript "scripts\DW\DWEnableEPFact.sql" 
Disable the Event Participant Fact table

From a command prompt in the \system subfolder of the CA DLP installation folder on the CMS, run the following command:

wgninfra -localexec wigan/schema/Schema RunScript "scripts\DW\DWDisableEPFact.sql" 

More information:

Do I Need To Collect Event Participant Data?