Platform Deployment Guide › Data Warehouse › Advanced Configuration › Retrospectively Enable the Data Warehouse › Enable Support for BusinessObjects Reports › 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 DataMinder 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 DataMinder, 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.