2.1.2.3 Lookup Table Grid

The Lookup Table Grid is essentially a table that displays the column type, the physical column name and the logical column name of the columns of the Lookup table.

The grid is displayed as blank in New mode while it displays the lookup table columns in View and Edit mode. The logical names of the columns are editable for user input.

The pane displays the physical database table name at the top of the grid.

The grid is populated by Add to Grid button available in the earlier pane.

Users can add return columns with the Add Return Coulmn button while any added column in the grid can be removed with the Delete button.

Figure 2-5 Lookup Table Grid in New mode

Once a instrument column has been added in the grid, the same column becomes un-selectable the next time the user wants to select and add to the grid.

The Lookup Table rule supports three column types:

• Range Lookup: for all instrument non-dimension columns.
• Exact Match: for all instrument columns – both dimension and non-dimension.
• Hierarchy Match: for all instrument dimension columns.

The default column type value for a non-dimension column is Exact Match, while the default column type value for a dimension column is Hierarchy Match.

Figure 2-6 Lookup Table Grid in View mode for a table in Draft status

In Draft state, the physical table name remains displayed as ‘LOOKUP_TABLE_DRAFT’ while in the table Created state, the database table name is displayed under the Physical Lookup Table Name field.

The physical column names are disabled for user input and takes up the names as per the design while the logical column names can be modified by the user as per requirement.

Figure 2-7 Lookup Table Grid in View mode for a table in Table Created status