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

4 comments:

  1. Hi Geeta,
    I'd like to contribute with your blog.
    Could it be possible?
    If it is, tell me how could we work together.
    Best Regards,
    Manuel
    Oracle-Brazil

    ReplyDelete
  2. Oracle EPMA Templates - I am not finding these templates for downloading.. Can you help me? Pleaseeeee... tks in adv !!! Erica

    ReplyDelete
  3. Thanks for Information Our Online-Training-Informatica proven expert in all Hyperion Modules like Hyperion Financial Management, Hyperion Financial Data Quality, Hyperion Financial Reporting, Hyperion Essbase, Hyperion Planning, Smart view and Data Relationship management.Hyperion Essbase Online Training

    ReplyDelete
  4. Hi, thanks for sharing your informative content. I really love this types of infromative blogs. I have studied more about how to integrate DRM Data Relationship Management with HFM. thank you.

    ReplyDelete