1 Reply Latest reply: Aug 23, 2013 12:49 PM by DRMRocks RSS

    How to create Import format for building  version Hirerarchy and Node

    1012870

      Hi

       

      i Want to know  how to create  Import format for building version  Hirerarchy and Nodes.Can anyone  show me with example  or format  for version  Hierarchy  with few nodes for the hierarchy

       

       

      i Want to Build   this   1. Version1 (Version)

                                       2.Account (Hirerarchy)

                                       3. Balancesheet (Limb)

                                       4. Assets (Limb)

                                       5. Cash (Leaf)

       

      Thanks,

        • 1. Re: How to create Import format for building  version Hirerarchy and Node
          DRMRocks

          Please follow the DRM User Guide,

          http://docs.oracle.com/cd/E17236_01/epm.1112/drm_user.pdf

           

          Below is my preferred approach, by selecting only relation and Hierarchy sections,

           

          • The relation section contains the Node Name and Parent Name ( you can include any other properties, but as a best practice keep the Parent Node as the last column).
          • The Hierarchy ( Hier ) section contains the Hierarchy Name, Top Node and Hierarchy description
          • Follow the Import steps and provide a Name for the version.

           

          ++++++++++++++++++++++++++++++++

          [relation]

          AC_BalanceSheet AC_Account

          AC_Asset AC_Account

          AC_Cash AC_Account

          [hier]

          Account AC_Account AccountHier

          ++++++++++++++++++++++

           

          Note: Please delete all the special characters (TAB) created at the end of  [relation] and [hier] sections while you copy the content from an Excel sheet to a Notepad.