Oracle® Business Intelligence Applications Installation and Configuration Guide > Checklist for Configuring Oracle Business Analytics Warehouse Applications >

Checklist for Configuring Oracle BI Applications Consumer


This section contains the mandatory and optional configuration points for the Oracle BI Applications Consumer application for Universal Source and post-load processing (PLP).

Checklist for Configuring Oracle BI Applications Consumer for Universal Source

This section contains the Oracle BI Applications Consumer application configuration points that are specific to universal source.

The following section contains mandatory Oracle Contact Center Telephony Analytics configuration points:

  • Dimension Key Resolution. When creating the source files, the data and the format of the reference to the Dimension data (foreign key ID column) must match the INTEGRATION_ID in the corresponding dimensional source file. This is critical for accurate resolution of the foreign keys on the fact record when loading the data warehouse. For more information on Dimension key resolution, see About the Dimension Key Resolution Process for Universal Source.
  • Representative Activities spanning a date boundary. If a representative's activity spans across the date boundary, then you must provide two different records for that representative for the same activity with different activity start dates and times. For more information on dates and setting up the Representative Activities table, see Setting Up the Representative Activities Table.
  • Setting the effective date ranges for Benchmark and Targets. When configuring the source files for the Benchmarks and Targets fact table, you need to make sure that the targets and benchmarks cover the time periods for the capture of the Contact Center Performance and Representative Activity data. For more information on setting the effective date ranges for Benchmark and Targets, see Setting Up the Benchmarks and Targets Table.

The following section contains optional Oracle Contact Center Telephony Analytics configuration points.

  • Configuring flags. Many of the fact and dimension tables within the Oracle Contact Center Telephony Analytics application use flag fields to provide value-added information pertaining to a contact or contact representative. These flag fields have logic to assign a default value to the flag while reading from the source files. For more information on configuring flags, see Configuring Flags for Oracle BI Applications Consumer.
  • Excluding calls from the Answered Contact Count. You may choose not to count calls which are completed in the IVR as an answered call. To do this you need to flag such calls with a new contact status. For more information excluding calls from the Answered Contact Count, see Setting Up the Contact Center Performance Table.

Checklist for Configuring Oracle BI Applications Consumer for post-load processing

The following section contains an optional configuration point for Oracle BI Applications Consumer that is specific to post-load processing.

Excluding representative data from the Contact Representative aggregate tables. For more information on excluding representative data from the Contact Representative aggregate tables, see Excluding Representative Data for Post-Load Processing.

Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.