Dac Course Content


Overview of Oracle Business Analytics Warehouse

·         Oracle Business Analytics Warehouse Overview
·         Oracle Business Analytics Warehouse Architecture.
·         Oracle Business Analytics Warehouse Architecture Components

DAC Basics

·         Introduction to Dac
·         About the DAC Process Life Cycle
·         Source System Containers
·         Repository Objects
·         User Account Management
·         Extract and Load

Setup View Tabs

·         DAC System Properties Tab
·         Email Recipients Tab
·         Informatica Servers Tab
·         Physical Data Sources Tab

Design Tab

·         Configuration Tags Tab
·         Indices Tab
·         Source System Folders Tab
·         Source System Parameters Tab
·         Subject Areas Tab
·         Tables Tab
·         Task Groups Tab
·         Tasks Tab

Execute View Tabs

·         Current Run Tab
·         Execution Plans Tab
·         Run History Tab
·         Scheduler Tab

Calendars in Oracle BI Applications

Oracle Business Intelligence Applications Version 7.9.6 supports the following calendar formats:
  • Enterprise (Global) - cross functional reporting calendar, which can be fiscal or gregorian.
  • Fiscal - accounting or financial calendar.
  • Gregorian - regular calendar that starts on January 1st and ends on December 31st.
  • 13 Period - a calendar is which each year is comprised of 13 periods.
  • 4-4-5 - each year is composed of twelve periods of either four weeks of 28 days or five weeks of 35 days.

Configure Initial Extract Date


Initial Extract Date is required when you extract data for a full load. It reduces the volume of data in the initial load.

The specified initial extract date will be used as a filter on the creation date of the transactional data in the selected full extract mapping.

The default date is January 01, 1970.

When you set the Initial Extract Date parameter, ensure that you set it to the beginning of an accounting period and not a date in the middle of an accounting period.

For example, if you decide to extract data from June 2005, and the June 2005 accounting period starts on June 5, set the date to June 5, 2005.


To configure the initial extract date:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
2. Display the Source System Parameters tab.

3. Edit the value of the $$INITIAL_EXTRACT_DATE parameter.

4. Save your changes.