Creating Mappings Using the Between Method

Between mappings enable you to enter a range of source values, separated with a comma. The range of source values are replaced with one target value. Use a between mapping to consolidate several accounts from your ledger to a single account in the plan.

  To create a Between mapping:

  1. On the Workflow tab, under Data Load, select Data Load Mapping.

  2. From Dimensions, select the dimension name.

  3. Select the Between tab.

  4. Click Add.

  5. Enter source values in the Source Value range.

  6. Enter the Target Value or click Image shows Search button to select a member.

    The target value is the dimension member name. 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 for the mapping.

  10. 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 the default, mappings specified at a location apply to all data rules in a location.

  11. Click Save.