6.3.4.2.1 Lookup Table Details
Specify the Lookup Table rule's Name and Description, select a Folder in which the Lookup Table rule is to be stored, and specify whether you want the Lookup Table rule to be “Read/Write” or “Read Only” (Access Type). Naming your Lookup Table rule is required before you save it. The default values for Folder and Access Type are stored in User Preferences.
Figure 6-68 Lookup Tables - Details tab
Lookup Table Definition
Select a Source table to create your Lookup Table. The source table list is limited to the instrument tables available under PBSMCS. The Source column dropdown lists all the columns available in the selected source table except the VARCHAR domain type columns.
Click on the ‘Add to Grid’ button to include the selected column into the Grid.
Figure 6-69 Lookup Tables – Lookup Table Definition tab
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 grid is populated by the ‘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.
The user can feed in or view or delete lookup table data from the Lookup Table Data screen that can be invoked from the Detail screen through the ‘Table Data’ button. The 'Table Data' button is enabled only for Lookup tables in 'Table Created' state and the detail screen mode being View.
Once an 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.
Figure 6-70 Lookup Table Definition with the Grid filled in a New mode
