Manage Domain Mappings and Hierarchies: Warehouse Domain Hierarchies Tab

Use this tab to check that the domain hierarchies have been set up correctly in Oracle Business Analytics Warehouse. You can also change how domain values are mapped from the source system to Oracle Business Analytics Warehouse.

Domain Hierarchies are displayed in inverted format, that is in the following format:

<Child 1>\
      <Child n>\
              <Parent>
Element Description

Domain Mappings

Use this list to navigate the domain hierarchies in Oracle Business Analytics Warehouse. For example, in a Financials target warehouse, the Group Account domain W_GL_GROUP_ACCOUNT is the parent domain to Financials Statement Item W_FIN_STMT.

Domain Member Mappings

Use this list to view and edit the members for the domain that is currently selected in the Domain Mappings list above.

Use the Source Members drop-down list to change the type of domains displayed. For example, select Unmapped to locate source domains that are not mapped to target domains. Select Mapped to display only source domains that are mapped to target domains. The default value 'All' displays both mapped and unmapped domains.

Edit Domain Member Mappings (Edit icon) - Use this option to display the Edit Domain Member Mappings dialog, which enables you to edit the values in this list. If a domain has been defined as extensible, then you can also create ranges and categories (or Ranges).

If the Edit Domain Member Mappings icon is grayed out, then the Domain is non-extensible (contact your BI administrator).

View menu

Use the View menu options as follows:

  • Expand — use this option to expand the currently selected node.

  • Expand All Below — use this option to expand all levels below the currently selected node.

  • Expand All Above — use this option to expand all levels above the currently selected node.

  • Expand All — use this option to expand all nodes at all levels.

  • Collapse All — use this option to collapse all nodes at all levels.

  • Show as Top (child nodes only) — use this option to display the currently selected tree branch and hide the other tree branches.

  • Go Up — display the next level of parent nodes.

  • Go to Top — use this option to display the top level of parent nodes.

Search (Only displayed when this dialog is invoked directly from Configuration Manager. Search is not available when this dialog is invoked from FSM.)

For User Assistance on the Search pane, see Search pane.