Creating Mappings Using the Like Method

Like mappings enable you to enter a string in the source value that is matched and replaced with the target value.

To create a Like mapping:

1. On the Workflow tab, under Data Load, select Data Load Mapping.
2. From Dimensions, select the dimension name.
3. Select the Like tab.
4. Click Add.

   A blank row is added.

5. Enter the Source Value string.

   The source value is the Enterprise Resource Planning (ERP) segment value. Like source write-back mappings support special characters. See Using Special Characters in the Source Value Expression for Like Mappings.

6. Select the Target Value or click to select a member.

   The target value is the EPM dimension member name. Like target write-back mappings support special characters. See Using Special Characters in the Target Value Expression.

7. To reverse the sign of the target account specified, select Change Sign.
8. Enter the Rule Name.
9. In Description, enter a description of the Like.
10. Select Apply to Rule to apply the mapping only to a specific data rule in a location.

    For other data rules in the location the mappings are not applied.

    By default, mappings specified at a location apply to all data rules in a location.

11. Click Save.