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 if you want to consolidate several accounts in your plan to a single account in the ledger.

  To create a “between” mapping:

  1. Click Add.

  2. 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.

  3. Enter the Target Value or click Search button. to select a member.

    The target value is the EPM dimension member name. See Using Special Characters in the Target Value Expression.

  4. Enter the Rule Name.

  5. Optional: Enter a description.

  6. Click Save.