Reports Integration Guide › Deployment › Enable Support for BusinessObjects Reports › Configure the Event Participant Fact Table

Configure the Event Participant Fact Table

Before you can populate the Event Participant Fact table, you must enable and configure the Event Participant table. Run the following commands to schedule a data warehousing job. The job performs the initial table configuration.

SQL Server Host Servers

Run this command:

EXEC WgnDW_Configure_DW 
  @Is_EP_Fact_Enabled = 1,
  @offpeak_run_starttime_hour = <hour>,
  @offpeak_run_timeout_mins = <minutes>,
  @Fact_Expiry_Age_Months = 0,
  @no_older_than_date = null

Where:

Is_EP_Fact_Enabled

Set this parameter to 1 to enable the Event Participant Fact table.

offpeak_run_starttime_hour

Use this parameter to specify the starting hour for the job. It can be any value from 0 to 23. For example, 0 specifies a midnight start; 23 specifies an 11 pm start.

offpeak_run_timeout_mins

Use this parameter to specify the window duration (in minutes) for the job. For example, set this to 240 to specify a four hour window

Fact_Expiry_Age_Months

Use this parameter to specify the maximum age (in months) of events stored in the data warehouse. If an event is older than n months, it gets purged when the next data warehousing job runs.

For example, if you set this parameter to 60, the data warehouse retains events up to 5 years old. Event solder than 5 years are purged.

If you set this parameter to zero, no events are purged). We recommend that you set this parameter to zero if you want the data warehouse to be axactly synchronized with event tables in your CMS database.

no_older_than_date

Use this parameter to limit the age of events that get copied into the data warehouse. The parameter specifies a timestamp. Only events captured on or after this date are copied into the data warehouse. Events captured before this date are excluded and not copied to the data warehouse.

For example, to specify a date of 6:00 am, 1 April 2012:

@no_older_than_date='2012-04-01 06:00:00'

Set this parameter to null to include all events. If you omit this parameter, events older than 3 days are excluded.

Oracle Host Servers

Run this command:

BEGIN
  WgnDW_Configure_DW( 
    Is_EP_Fact_Enabled => 1,
    offpeak_run_starttime_hour => <hour>,
    offpeak_run_timeout_mins => <minutes>,
    Fact_Expiry_Age_Months => 0,
    no_older_than_date => null );
END;

Where the parameters are as described above.