Multi-dimensional mapping is ideal for complex scenarios where a single field isn't enough to determine the correct mapping. For example, you can use a combination of a GL Account and a Cost Code to map to a Functional Area.

Multi-dimensional mapping works like traditional mapping tables. The difference is that it uses a combination of multiple Source Fields to determine the Mapped Value. It remains fully compatible with all traditional mapping functionalities, including Wildcard, SKIP, and BLANK.

As with traditional mapping, the order of the combinations in the mapping table is important. Records are processed against the first match they encounter.

Create multi-dimensional mapping

Multi-dimensional mapping concatenates the code of all the elements to perform a lookup in the targets. To create multi-dimensional mapping:

  1. First, ensure you have a staging table with two or more columns that you can use as source fields.
  2. Navigate to Configure > Maps and select the Add new Map icon.
  3. In the Mapping Options, select the Multi-dimensional Mapping checkbox.
  4. Select the appropriate staging table from the Staging table dropdown.
  5. Select two or more Source Fields checkboxes to define the target. 
  6. Select Save. Once the mapping table is saved, you can add new combinations. 
  7. On the mapping table row, select the ellipsis and choose Edit Mappings. The grid will display separate Mapping Types, Source Values, and Source Caption columns for each source field you selected.  Define the combination of source values and the corresponding Mapped Value.

Note: Once the multidimensional mapping is saved, the Multi-dimensional Mapping option is grayed out for the mapping table. The source fields can be edited until the multi-dimensional map is used in a data import definition. 


Use multi-dimensional maps

Typically, when you have a map, you need to identify the source fields. The mapping table directly provides the Source Fields, so you don't need to re-select them. The system automatically filters for Member Maps marked as multi-dimensional that share the same staging table as the data import definition.

To use a multi-dimensional map:

  1. After creating a multi-dimensional map, select Configure > Data Import Definition.
  2. On a data import definition row, select the ellipsis, and choose Edit Field Mappings.
  3. For the target field you wish to map, for example, Product, change the Mapping Method to Multi-Dimensional Map.
  4. In the Member Map column, select the multi-dimensional mapping table you created. The system automatically filters the list to show only maps flagged as multi-dimensional that share the same staging table as your import definition.

Related content