About Me

Anjum Ara I am a technology enthusiast, an ardent reader. My latest interest is virtualization. In my free time, I love understanding child nutrition, child holistic development. I bake, read, paint, and do whatever it takes to improve myself every day.

Thursday, April 22, 2021

Format EPMA Hierarchy into DRM Format Hierarchy

EPMA is deprecated from the EPM 11.2.X Version so one impending question is "What about our EPMA applications?" 

There are two options 
  • Convert EPMA applications to Classic application
  • Use DRM to manage the metadata

I intend to write a series on each step required to convert EPMA app to DRM compliant application and one of the first step is re-formatting the ADS file exported from the EPMA into a DRM readable format.


                                

Pre-requisites
Description:
               The formatting is done as below
  • 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 

       

Share:

Monday, April 12, 2021