1. Integrating Oracle Data Relationship Management Suite with Enterprise Performance Management
  2. Using Data Relationship Management with FDMEE
  3. Configuring FDMEE Metadata in Data Relationship Management
  4. Configuring Domains

Configuring Domains

Domains are optional for the integration. They are needed when the dimensions from the source systems contain nodes of different types with the same name. An example would be both an account 1234 and a product 1234. Domains can make these nodes independent of each other with the use of the domain qualifier.

The Oracle Hyperion Financial Data Quality Management, Enterprise Edition integration passes in an Oracle Data Relationship Management domain qualifier in the staging tables used by the imports. This information can be used by the import and blender Data Relationship Management processes to use Data Relationship Management domains. The Data Relationship Management domain value to be used is specified in FDMEE.

The imports and blender in the FDMEE application template are preconfigured to work with domains.

Note:

After import, the nodes are not put into the domains. This can be done manually or as part of a blend process.

Creating Domains in Data Relationship Management

Create a Data Relationship Management domain for each value to be passed in from FDMEE.

Note:

The Data Relationship Management user needs to have the Application Administrator role.

To create a domain:

  1. On the Data Relationship Management Home page, click Administer.

  2. From New, select Domain.

  3. Enter a name and description for the domain.

  4. Enter a Qualifier and Delimiter as needed to prevent conflicts between dimensions.

  5. Determine if there should be a suffix or prefix. Prefix is the default and most used form.

  6. Click Save.

Manually Setting Domains for Imported Nodes

The nodes can be added to the appropriate domains after import.

Note:

The Data Relationship Management user needs to have the Application Administrator role.

To add nodes to domains after import:

  1. On the Data Relationship Management Home page, click Browse and then click the version to work with.

  2. Click the Property button to display Version Properties.

  3. Set up the Version Property in the System Category “Domains in Use” with the domains to be used.

  4. Click Save.

  5. Right click the version and select Domain Membership.

  6. Set the Override Property to the FDMEE.Node Domain Qualifier.

  7. Click OK.

Using the Blender to Set Domains for Imported Nodes

When blending the nodes from the import version to the production version, the blender is set up to put the nodes into the domains for the target version.

Note:

If domains are set up to prevent conflicts of names, then the domains need to be configured in the version where the mapping is done as well as the versions to which the source system nodes were imported. Failure to do so will result in the suffix or prefix not being removed in the export that provides the mappings to FDMEE and will cause a mapping failure.