Search This Blog

Thursday, November 3, 2011

Integrating DRM with HFM

Based on a request from a blogger below are a few steps to integrate HFM and DRM.

Oracle EPMA Templates: 
Download the EPM Application Templates for Hyperion Data Relationship Management from the Oracle website. http://www.oracle.com/technetwork/middleware/data-relationship-management/downloads/index.html

Customize the templates as advised based on the Dimensions/ Hierarchies/ Properties defined/ customized in your instance of HFM.

Populating HFM data into DRM:

Note that the templates create the DRM Metadata elements and you will need to create Import profiles in DRM to populate the data from HFM to DRM. The import file will need to be delimited based on the DRM defined format (with defined [hier], [relation] sections etc.)

Feedback loop into HFM/ Writing DRM data back to HFM:

The EPMA template creates DRM Export profiles for the HFM Accounts and Entity Dimensions. You will need to configure additional Dimensions that need to be exported back to HFM from DRM.

Use EPMA to import data exported from DRM into ADS specific file formats into HFM. This is not a XML import to HFM. Alternately using Interface tables (component of EPMA) you can map the DRM exports to write to the Interface tables and integrate with HFM accordingly.

Hope that helps.

-Geeta

Wednesday, November 2, 2011

DRM_DB Metadata Repository Model v 11.1.2.1.103

Disclaimer: Oracle recommends that DRM administrators / users should not change content in the Underlying metadata tables.

Below is a reverse engineered DRM_DB data model (DRM metadata repository). Understanding the model from a high level is very useful for any DRM administrator. In a following post I will explain the function of certain key tables.