importMapping

Imports mappings from a mapping import file, which was previously uploaded to the environment.

A Service Administrator uses the uploadFile command to upload files into Data Management inbox or a folder within it.

Applies to

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Account Reconciliation, Profitability and Cost Management, Enterprise Profitability and Cost Management, Sales Planning, and Strategic Workforce Planning.

Required Roles

• Service Administrator
• Power User

Usage

epmautomate importMapping DIMENSION_NAME|ALL FILE_NAME IMPORT_MODE VALIDATION_MODE LOCATION where:

• DIMENSION_NAME|ALL indicates the recipient of the mapping. Specify the name of the dimension into which mappings are to be imported or ALL to import all mappings included in the file to appropriate dimensions.

• FILE_NAME is the name and location of the mapping import file available in Data Management inbox or a directory within it. Specify the file name (TXT files in standard Data Management format) and its path (for example, inbox/AccountMap.txt or inbox/pbcs_maps/AccountMap.txt).

• IMPORT_MODE is either REPLACE to clear existing mapping rules before importing mappings or MERGE to add new mapping rules to exiting rules.

• VALIDATION_MODE is TRUE to validate target members against the application or FALSE to load the mapping file without running validations.

• LOCATION is the Data Management location for which mapping rules should be loaded.

Examples

• epmautomate importMapping Account inbox/AccountMap.txt MERGE FALSE "France Sales"
• epmautomate importMapping ALL "inbox/France Sales/AllMaps.txt" MERGE FALSE "France Sales" (loads mappings from the mapping import file into all mapped dimensions in France Sales location)