Using In Mappings

To use an In member mapping:

1. From the Data Integration home page, click to the right of the integration, and then select Map Members.
2. Click Edit.
3. From the Dimension drop-down, select the dimension to which to edit or add member mappings.
4. Click to add a new member mapping.
   You can also just edit existing mappings as needed without adding a new mapping.
5. In Source, click from the Mapping Type drop-down and then specify the source values.

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

   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.
6. In Target, enter the target value for the dimension member name.
7. 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.

8. In Description, enter a description of the mapping.
9. 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 Oracle Enterprise Performance Management Cloud applications, positive numbers are often loaded as credits and all negative numbers are loaded as debits. Consequently, you can reverse the sign.

10. Click Save.