Reports Integration Guide › Deployment › Data Warehouse › Enable the Data Warehouse at Install Time › Manually Enable the Event Participant Fact Table

Manually Enable the Event Participant Fact Table

You manually enable the Event Participant Fact table by running a wgninfra.exe command. You can also manually disable the 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"

Note: If you already use the iConsole dashboard but now want to start running BusinessObjects reports for CA DLP, you must enable and populate the Event Participant Fact table. It is not sufficient to simply run the above command. You must also resync the table or truncate and repopulate the data warehouse, depending on your CMS purging strategy.