If you regularly purge events from you CMS database, it is likely that your data warehouse contains events that no longer exist on the CMS. Specifically, the participant details for these events no longer exist in the CMS database and cannot be processed into the data warehouse Event Participant Fact table. In this situation, we recommend that you truncate and repopulate the entire data warehouse to avoid discrepancies in report results.
Run the following commands to truncate and repopulate the data warehouse tables.
Run this command:
EXEC WgnDW_Configure_DW @Truncate_On_Next_Run = 1
Where:
Truncates and repopulates the data warehouse tables. This operation ensures that events in the data warehouse, including the Event Participant Fact table, exactly correspond to the event tables in the CMS database.
Run this command:
BEGIN
WgnDW_Configure_DW(
Truncate_On_Next_Run = 1 );
END;
Where the Truncate_On_Next_Run parameter is as described above.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|