Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Customizing, Designing, Executing and Monitoring ETL Processes >

Creating a Subject Area

When you create a new subject area, you assign one or more fact tables to the subject area. The DAC then determines which dimension and other related tables are required as well as the tasks and their order of execution.

To create a new subject area

1. In the DAC, select the appropriate source system container from the drop-down list in the toolbar.
2. In the Menu bar, click Views > Design > Subject Areas.
3. In the top pane toolbar, click New.
4. In the Edit child tab, enter a name for the subject area, and click Save.
5. Make sure the new subject area name is highlighted in the top pane, and click the Tables child tab.
6. Click Add/Remove in the child tab toolbar.

   The Choose Tables dialog box opens. The left-hand window lists all the tables held in the selected container.

7. Query for one or more fact tables.
8. Select the fact table (use Shift+click to select more than one table), and click Add.

   The tables are added to the right-hand window, which represents the subject area.

9. Click OK to close the Choose Tables dialog box.
10. In the top pane toolbar, click Assemble.
11. In the Assembling... dialog box, select Selected Record Only.

    If you select the option All Records in the List, the DAC will reassemble all the subject areas listed in the top pane.

    The DAC assembles the selected subject area by determining what dimensions and other related tables are required and what tasks are needed to load these tables.

    You will receive an informational message when the assemble process is completed.

12. Click the Tasks tab to view which tasks the DAC has determined are required for this subject area.

    Tasks that are automatically assigned to the subject area by the DAC are indicated with the Autogenerated check mark.

    You can inactivate a task from participating in the subject area by selecting the Inactive check box. When the Inactive check box is selected, the task remains inactive even if you reassemble the subject area.

    You can also remove a task from the subject area using the Add/Remove command, but when you remove a task it is only removed from the subject area until you reassemble the subject area.