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 is replaced with a single 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.

   Separate source values with a comma, for example, specify 100,199. Between mappings do not support special characters, such as an asterisk.

6. Enter the Target Value or click 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 mappings are not applied.

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

11. Click Save.