Creating Mappings Using the Like Method

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

  To create a Like mapping:

  1. Select Workflow, and then under Data Load, select Data Load Mapping.

  2. In Data Load Mapping, in the Dimensions drop-down, 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 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 Image shows Search button 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 mapping are not applied.

    By the default, mappings specified at a location are applicable to all data rules in a location.

  11. Click Save.