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
- Login to the DAC repository and select the Universal container.
- Go to the SDE_Universal task and click on the parameter tab.
- 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
|
INTEGRATION_ID Expression |
|
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 |
|