Bookshelf Home | Contents | Index | PDF     

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

Configuring Dates and Times

The Contact Center Telephony Analytics application supports analysis by both the local date/time and the Warehouse date/time. On the fact tables, the _LDT columns refer to the local date and time while the _DT fields refer to the warehouse date and time. If you want to capture the local date and time on a transaction, you will need to provide that data in the _LDT columns through the flat file interface. You will also have to apply the appropriate transformation to compute the warehouse date/time and supply this in the _DT columns through the flat file interface. Even if you choose not to support analysis based on local time, you will need to supply data for the _DT (warehouse date/time) columns. The table below provides a list of the applicable local date columns for each fact table.

Table 51. Date Columns and Flat Files
Flat file
Applicable Date Column
Applicable Local Date Column
Table Using the Local Date

file_rep_activity.csv

ACTIVITY_START_DT, ACTIVITY_END_DT

ACTIVITY_START_LDT, ACTIVITY_END_LDT

W_REP_ACTIVITY_F

file_acd_event.csv

EVENT_START_DT, EVENT_END_DT

EVENT_START_LDT, EVENT_END_LDT

W_ACD_EVENT_F

file_cntct_cntr_perf.csv

CNTCT_START_DT, CNTCT_END_DT

CNTCT_START_LDT, CNTCT_END_LDT

W_CNTCT_CNTR_PERF_F

file_rep_activity_
hour.csv (Alternate Load)

ACTIVITY_DT

ACTIVITY_LDT

W_REP_ACTIVITY_
HOUR_A

file_cntct_cntr_perf_rep_hour.csv (Alternate Load)

CNTCT_DT

CNTCT_LDT

W_CNTCT_CNTR_PERF_REP_HOUR_A

To provide local dates in the flat file interface

  1. Open the applicable flat file interface.
  2. In the flat file interface, input the new dates in the *_DT fields.
  3. Input the corresponding local dates in the *LDT fields.
  4. Save your changes to the flat file interface.
  5. Run a test load for 10 records to verify that your new dates are loaded into the applicable table.
  
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.