Adding Lookup Dimensions

Lookup dimensions can be created and assigned with data columns for target applications. Lookup dimensions are used for mapping and reference. They can only be used in FDMEE and do not affect 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. On the Setup tab, under Register, select Target Application.

  2. In the Target Application summary grid, select a target application.

  3. Select the Dimension Details tab.

  4. Click Add.

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

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

  6. In Data Table Column Name, select the data column from which to base the lookup dimension.

  7. Click OK.

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