3.6.2.3 Lookup Key Columns

The Lookup Key Columns grid displays the columns defined for the Lookup Table. Click Delete Lookup Key Column at the top right of the pane to remove a selected column.

The grid contains the following columns:

• Lookup Type: The type of lookup for the column. Three column types are supported:
  • Range Lookup: For non-dimension instrument columns. Stores a range of values between a minimum and a maximum. The logical condition is: Range Lookup Minimum value ≤ matching instrument data ≤ Range Lookup Maximum value. Lookup data must not have overlapping ranges, as this leads to ambiguous results.
  • Exact Match: For all instrument columns, both dimension and non-dimension. Performs a literal database join and supports numeric values, dates, and strings.
  • Hierarchy Match: For instrument dimension columns. Allows matching on dimension member values from a source instrument table with any leaf member that belongs to a hierarchical rollup point. Supports only Key Processing dimensions.
• Physical Column Name: Displays the physical database column name.
• Logical Column Name: Displays the logical (user-facing) name of the column. This field is editable.
• Hierarchy: Applicable for Hierarchy Match column types. Displays the hierarchy associated with the dimension column.
• Code Match Column: Indicates whether the column is designated as a code match column.

You can drag and reorder columns in the grid. The physical database table is created with the columns in the order shown in the grid. To reorder, hold and release the left mouse button on the Logical Column Name column.

Once a column has been added to the grid, it becomes unselectable in the Target Column Selection dropdown to prevent duplicate entries.