Using Like Mappings

To use a Like member mapping:

  1. From the Data Integration home page, click Image shows Select icon. to the right of the integration, and then select Map Members.
  2. Click Edit.
  3. Click Image shows Add icon to add a new member mapping.
    You can also just edit existing mappings as needed without adding a new mapping.
  4. In Source, click Image shows Like iconfrom the Mapping Type drop-down and then specify the source value.
    When specifying the source value for a Like mappings, you can use special characters as parameters. See Using Special Characters in the Source Value Expression for Like Mappings.

    Note:

    When processing the source values for transformations, multiple mappings may apply to a specific source value. The order of precedence is Explicit, Between, In, Multi-Dimensional, and Like.
  5. In Target, enter the target value for the dimension member name.
  6. In Processing Order, specify the order of the mapping.

    The processing order determines the level of precedence within a mapping type. Mappings are processed in alphabetical order by the name within a mapping type. Numbers may also be used to help with ordering. For example, if you use Number for processing, note that the processing order is an alphanumeric sort order. If have 10, 20, 30, 100 as the order, the processing order will be 10, 100, 20, 30. When using numbers for the processing order, use the same number of digits for all maps.

  7. In Description, enter a description of the mapping.
  8. Select Change Sign to reverse the sign of the target account specified.

    The Change Sign option is often used with General Ledger source data when the trial balance has negative signs for Revenue and Liability/Equity source accounts. In EPM applications, positive numbers are often loaded as credits and all negative numbers are loaded as debits. Consequently, you can reverse the sign.

  9. Click Save.