Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle BI Applications Consumer >

Configuring Alternate Load Plan to Enable Direct Load to the Entry-Level Rep Activity Aggregates

The Representative Activity fact table stores information at an individual representative activity grain. In case the data is not available at the point in time grain, you can alternately choose to provide summarized data at the hourly level and load the Rep Activity hour level aggregate table W_REP_ACTIVITY_HOUR A directly.

This data will be used by the post-load process to load the following day and month level aggregates:

• W_REP_ACTIVITY_DAY_A
• W_REP_ACTIVITY_MONTH_A

To configure the alternate load plan to directly load aggregate table

1. Login to the DAC repository
2. Select the Universal container
3. Choose Design > Subject Area and query for the "Service - Rep Activity" subject area.
4. With this subject area selected, in the detail pane, click on Configuration Tags.
5. Uncheck the configuration point "ECC- Load into base fact and then aggregates".
6. Check the configuration point "ECC - Load directly into aggregate facts".
7. Redesign the subject area "Service - Rep Activity" and save.
8. Redesign the execution plan "Universal Contact Center Telephony Analytics".

To provide hour level data

1. Open the file rep_activity_hour.csv using a text editor from $PMRootDir\SrcFiles folder.
2. Enter the data for Representative activities at the hourly level.
3. Save and close the file.