MicroStrategy ONE

Alter Attribute Form Expression statement

Modifies an expression mapping mode in an attribute form for a given attribute within a project.

Copy 
ALTER ATTRIBUTEFORMEXP EXPRESSION [OVERWRITE] [LOOKUPTABLE lookup_table] [MAPPINGMODE (AUTOMATIC | MANUAL)] EXPSOURCETABLES sourcetable1, [,sourcetable2[, ...sourcetableN]]) FOR ATTRIBUTEFORM form_name FOR ATTRIBUTE attribute_name IN [FOLDER] location_path FOR PROJECT project_name;

where:

  • expression is the expression to be modified 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 (").

  • sourcetableN is the name of the source table to be used in 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 (").

  • 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 
ALTER ATTRIBUTEFORMEXP "ORDER_DATE" MAPPINGMODE AUTOMATIC EXPSOURCETABLES "ORDER_DETAIL", "ORDER_FACT" FOR ATTRIBUTEFORM "ID" FOR ATTRIBUTE "Day" IN FOLDER "\Schema Objects\Attributes" FOR PROJECT "MicroStrategy Tutorial";