Creating Mappings Using the Explicit Method

Explicit mappings enable you to enter a source value to be matched exactly and replaced with a target value. Use an explicit mapping to explicitly map the members from the source ledger to an EPM target application. For example, you can map Account1 to the Account100 in your EPM target application. This allows you to explicitly define how to dimensionalize the data file that is loaded into the target application.

To create an Explicit mapping:

Select Workflow, and then under Data Load, select Data Load Mapping.
The Data Load Mapping screen is displayed.
In the Dimensions drop-down, select the dimension name.
Select the Explicit tab.
Click Add.
Enter the Source Value or click to select a value.
See Using Special Characters in the Source Value Expression for Like Mappings.
Optional: Enter a description for the mapping.
Enter the Target Value or click to select a member.
The target value is the EPM dimension member name. See Using Special Characters in the Target Value Expression.
To reverse the sign of the target account specified, select Change Sign.
In Description, specify a description of the mapping.
Select Apply to Rule to apply the mapping only to the specific data rule in the location.
For other data rules in the location the mapping are not applied.
By default, mappings specified at a location are applicable to all data rules in a location.
Click Save.