Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

DAC Subject Area

In Oracle BI Application Data Warehouse Administration Console (DAC), you can use the subject area to manage your the ETL executions.

A subject area in DAC contains multiple fact tables and all the required tasks to populate them.  During the design time, you assign one or more fact tables to the subject area.  DAC will use the foreign key definition of the tables to identify the dimension tables together with the other related table information to come up a list of tables.  DAC will then identify the tasks that load these tables.

Subject areas are predefined by Oracle BI Applications.  You can make a copy of the shipped source  system container if you would like to configure the ETL process.  You can then add your own subject area or modify the predefined subject area.  Once DAC generate the tasks for you, you can also manually add, remove, activate, inactivate tasks from a subject area.