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: 

• ADS file exported from the application using EPM File Generator  (Guide to extract metadata into ADS file)
• Java 8 or above
• Patch downloaded from OTN Patch 30695700

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