Friday, May 21, 2021

Hyperion 11.2 and converting EPMA applications to Classic Mode or DRM Lite !

EPMA is deprecated from EPM 11.2.x version.  So if you are running the EPMA app, you now have two options:  

  • Convert EPMA applications to Classic application OR
  • Use DRM to manage the metadata
To convert EPMA to DRM, the first step is to re-format the ADS file, which you can export from the EPMA into a DRM readable format.

Pre-requisites
Formatting steps:
  • The Dimension section is converted to 'hierarchy' in the DRM
    • !Section=Dimensions to [hier]
  • The Hierarchies section is converted to 'relations' in the DRM
    • !Hierarchies=Scenario to [relation]
  • Delimiter supported is | and ;
  • There is no header line in the exported DRM format file as it does not support header description
  • The field names should not have a comma 
Steps:
     
  • Set Java in the environment variables
  • Command: java DRM_ADS ads_orig.txt ads_drmformat.txt

No comments:

Post a Comment