.If you have not purged any events from your CMS database, events in your data warehouse already correspond to events on the CMS. To enable support for BusinessObjects reports, you just need to resync the Event Participant Fact table. This operation ensures that all event participant details are copied to the data warehouse.
Run the following commands to resync the Event Participant Fact table.
Run this command:
EXEC WgnDW_Configure_DW @Resync_On_Next_Run = 1
Where:
Resynchronizes the Event Participant Fact table. This operation ensures that events and participant details in the Event Participant Fact table exactly correspond to the event tables in the CMS database.
Run this command:
BEGIN
WgnDW_Configure_DW(
Resync_On_Next_Run = 1 );
END;
Where the Resync_On_Next_Run parameter is as described above.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|