Importing LedgerLink Conversion Tables

FDM can read and import Hyperion LedgerLink Account and Name conversion tables. LedgerLink conversion tables must have the file extension .tra or the file extension .trn. FDM interprets ranges used in LedgerLink conversion tables as wildcards and generates the appropriate conversion table entries. Acceptable field delimiters are pipes ( | ), semicolons ( ; ), exclamation points ( ! ), and commas ( , ).

Note:

Because LedgerLink extracts do not include location or dimension IDs, the POV location and the dimension to which the mapping table is to be loaded must be selected before import begins. FDM imports .tra and .trn files to the selected POV and dimension.

  To import LedgerLink conversion tables:

  1. From Dimension, select the dimension into which to load the mapping table.

  2. Select the Upload File tab.

  3. Select the mapping table in one of two ways:

    • If the preferred table is not listed in Inbox, browse for and select it.

    • If the preferred table is listed in Inbox, from the Inbox tab, select it, and click Select File.

  4. Click Import to complete the import of the mapping table.

  5. Repeat steps 1–4 as many times as needed to load all mapping tables required for the application.