Loading GL Values and Hierarchies into Data Relationship Management

Importing Members from FDMEE

The import process is run using an Oracle Hyperion Financial Data Quality Management, Enterprise Edition metadata rule and will populate the staging tables and execute the Oracle Data Relationship Management import to create the version within Data Relationship Management.

See Oracle Hyperion Financial Data Quality Management Administrator's Guide.

Blending ERP Members to EPM Versions

The blend profile FDMEE Blend is set up to blend the versions imported from FDMEE into existing Data Relationship Management versions. The blend can be run manually within Data Relationship Management or it can be run at the end of a FDMEE metadata rule that imports the data into Data Relationship Management. This can be done by configuring the Blend after Import functionality on the import profiles used for the FDMEE import process.

Note:

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

To blend the ERP members to EPM version:

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

  2. Open the import profile by double clicking on it.

  3. Click on the Target tab.

  4. Select the Blend After Import checkbox.

  5. Select the appropriate blender (FDMEE Blend is the one supplied by the template) from the blender profile drop down list.

  6. The Default parameters in the supplied FDMEE Imports set the BLEND_TARGET parameter to be the FDMEE_MAP_VERSION variable. If this is not the desired target of the blend then this parameter needs to be changed to point to the appropriate version or version variable. It is recommended that you use a version variable so that the import profiles do not have to be modified as the target version changes. To set the Parameter BLEND_TARGET do the following:

    1. Click the Parameters button (Edit Parameters).

    2. Click on Edit button for the BLEND_TARGET row.

    3. Set the Value to the appropriate version variable or version.

    4. Click the Save button in the BLEND_TARGET row.

    5. Click OK on the Parameter Edit dialog box.

  7. Click the Save button to save the changes to the import profile