Adding Lookup Dimensions

Lookup dimensions can be created and assigned with data columns for target applications. Lookup dimensions are used for calculations and reference. They can only be used in ERP Integrator, and do not impact the dimensionality of a target application. They can also be used with member mapping functionality to cross reference multiple source segments and chartfields, and assign a target value.

  To add a lookup dimension:

  1. In the Tasks pane, select Target Application.

    The Target Application page is displayed.

  2. In the Dimension Details section, click Image shows Add Lookup Dimension button.

    The Add / Edit Lookup Dimension screen is displayed.

  3. Click Add button.

    Blank dimension name and data table column name entry fields are displayed.

  4. In Dimension Name, enter the lookup dimension name.

  5. In the Data Table Column Name drop-down, select the data column from which to base the lookup dimension.

  6. Click OK.

    The lookup dimension is added to the dimension detail list with the target dimension class name of “LOOKUP”.