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:
Select Workflow, and then under Data Load, select Data Load Mapping.
The Data Load Mapping screen is displayed.
Enter source values in the Source Value range.
The source value is the ERP segment value. Separate source values with a comma. For example 100,199. “Between” mappings do not support special characters, such as an asterisk.
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.
To reverse the sign of the target account specified, select Change Sign.
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 are applicable to all data rules in a location.