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 orALL
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
orinbox/pbcs_maps/AccountMap.txt
). -
IMPORT_MODE
is eitherREPLACE
to clear existing mapping rules before importing mappings orMERGE
to add new mapping rules to exiting rules. -
VALIDATION_MODE
isTRUE
to validate target members against the application orFALSE
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)