MicroStrategy ONE

Add Attribute Form statement

Adds a form with one expression to an attribute within a project.

Copy 
ADD ATTRIBUTEFORMform_name[FORMDESCform_desc] FORMCATEGORYcategory_nameFORMTYPE 
 (NUMBER | TEXT | DATETIME | DATE | TIME | URL | EMAIL | HTML | PICTURE 
 | BIGDECIMAL) [SORT (NONE | ASC | DESC)] EXPRESSIONform_expression[MAPPINGMODE 
 (AUTOMATIC | MANUAL)] [EXPSOURCETABLESsourcetable1, [,sourcetable2[, . . .sourcetableN]]] LOOKUPTABLElookup_table[MULTILINGUAL 
 (TRUE | FALSE)]TO 
 ATTRIBUTEattribute_nameIN [FOLDER]location_pathFOR PROJECTproject_name;

where:

  • form_name is the name of the form to be added, of type string, between double quotes (").

  • form_desc is the description of the form, of type string, between double quotes (").

  • category_name is the category name to be used in the form, of type string, between double quotes (").

  • form_expression is the expression to be added to the form, of type string, between double quotes (").

  • sourcetableN is the name of the source table to be used in the form, of type string, between double quotes (").

  • lookup_table is the name of the lookup table to be used in the form, of type string, between double quotes (").

  • attribute_name is the name of the attribute to which a form is to be added, of type string, between double quotes (").

  • location_path is the folder where the attribute resides, of type string, between double quotes (").

  • project_name is the name of the project, of type string, between double quotes (").

This statement can only be executed in a Windows environment.

Example

Copy 
ADD 
 ATTRIBUTEFORM "Last Name" FORMDESC "Last Name Form" 
 FORMCATEGORY "DESC" FORMTYPE TEXT SORT DESC EXPRESSION "[CUST_LAST_NAME]" 
 LOOKUPTABLE "LU_CUSTOMER" TO ATTRIBUTE "Customer" 
 IN FOLDER "\Schema Objects\Attributes" FOR PROJECT "MicroStrategy 
 Tutorial";