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
|
|
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
- Open the applicable flat file interface.
- In the flat file interface, input the new dates in the *_DT fields.
- Input the corresponding local dates in the *LDT fields.
- Save your changes to the flat file interface.
- Run a test load for 10 records to verify that your new dates are loaded into the applicable table.
|