How to define the lookup table for an attribute in MicroStrategy Developer
To define the lookup table of an attribute in Strategy Developer, follow these steps:
Open the Attribute Editor by double-clicking on the appropriate Attribute icon
NOTE: The table 'LU_COUNTRY' is in bold; this means that this table is the one selected as the lookup table for the attribute 'Country.'
To change the lookup table from 'LU_COUNTRY' to 'LU_REGION' (for example), click on 'Modify' in the Form definition section. The following window appears:
Highlight the table 'LU_REGION' under 'Source tables' and click on the 'Set as Lookup' button. The table now appears in bold as shown below.