MicroStrategy ONE
Add Attribute Form Expression statement
Adds an expression to a specific form in a given attribute within a project.
ADD
ATTRIBUTEFORMEXPexpression[MAPPINGMODE
(AUTOMATIC | MANUAL)][EXPSOURCETABLESsourcetable1, [,sourcetable2[, ...sourcetableN]]] LOOKUPTABLElookup_table[OVERWRITE]
TO ATTRIBUTEFORMform_nameFOR ATTRIBUTEattribute_nameIN [FOLDER]location_pathFOR PROJECTproject_name;
where:
-
expression is the expression to be added to the form, of type string, between double quotes (").
-
form_name is the name of the form to be added, 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
ADD ATTRIBUTEFORMEXP "ORDER_DATE" TO ATTRIBUTEFORM
"ID" FOR ATTRIBUTE "Day" IN FOLDER "\Schema Objects\Attributes"
FOR PROJECT "MicroStrategy Tutorial";