Bookshelf Home | Contents | Index | PDF     

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

Formation of Integration_Id of the Enterprise Contact Center Facts in the Warehouse

The INTEGRATION_ID by default is provided in the SrcFiles and they are unique for a DATASOURCE_NUM_ID in a fact. Alternately, they can also be formed in the warehouse in the SDE adaptor mappings using a set of Dimension_Ids and other columns of each record. The combination of Dimension Ids and other columns used for forming Integration_id is unique within a DATASOURCE_NUM_ID and identifies the grain of the fact. For example, in the W_ACD_EVENT_F fact table, INTEGRATION_ID is formed as CALLID_NUM||'~'||EVENT_SEQUENCE_NUM.

To set up formation of Integration_Id in SDE Adaptor

  1. Login to the DAC repository and select the Universal container.
  2. Go to the SDE_Universal task and click on the parameter tab.
  3. Change the value of $$READ_INTEGRATION_ID_FROM_FILE parameter to FALSE.

The following table lists the expression of INTEGRATION_ID for each fact and the SDE task that creates it.

Table 53. Expressions and Task Names
Table Name
INTEGRATION_ID Expression
Task Name

W_ACD_EVENT_F

CALLID_NUM||'~'||EVENT_SEQUENCE_NUM

SDE_Universal_ACDEventFact

W_CNTCT_CNTR_PERF_F

CNTCT_NUM||'~'||CNTCT_REP_ID||'~'||CNTCT_START_DT

SDE_Universal_ContactCenterPerformanceFact

W_CNTCT_CNTR_BNCHMRK_
TGT_F

PERIOD_START_DT||'~'||COMPANY_ORG_ID||'~'||CNTCT_REP_ID||'~'||REP_HR_ORG_ID||'~'||CNTCT_REP_ORG_ID||'~'||CNTCT_CNTR_LOC_ID||'~'||CHNL_TYPE_ID||'~'||CUSTOMER_ID||'~'||PRODUCT_ID

SDE_Universal_ContactCenterBenchmarkTargetFact

W_CNTCT_CNTR_PERF_REP_
HOUR_A

CNTCT_CNTR_LOC_ID||'~'||CNTCT_REP_ID||'~'||CNTCT_DT

SDE_Universal_ContactCenterPerformanceRepHourAggregate

W_REP_ACTIVITY_F

CNTCT_REP_ID||'~'||ACTIVITY_TYPE_ID||'~'||ACTIVITY_START_DT||'~'||ACTIVITY_START_LDT

SDE_Universal_RepActivityFact

W_REP_ACTIVITY_HOUR_A

CNTCT_REP_ID||'~'||ACTIVITY_TYPE_ID||'~'||ACTIVITY_DT

SDE_Universal_RepActivityHourAggregate

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