EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB4373: How to define the lookup table for an attribute in MicroStrategy Developer


Stefan Zepeda

Salesforce Solutions Architect • Strategy


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
ka02R000000kbn3QAA_0EM440000002GJS.gif
  •  
    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:
ka02R000000kbn3QAA_0EM440000002GJP.gif
  • 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.
ka02R000000kbn3QAA_0EM440000002GJO.gif
  • Click on 'OK' and save the Attribute.
  • Update the Schema.

Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017