MicroStrategy ONE

Alter Attribute statement

Modifies an attribute within a project.

Copy 
ALTER ATTRIBUTE attr_name IN [FOLDER] location_path [HIDDEN (TRUE | FALSE)] [NAME new_attr_name] [DESCRIPTION new_desc][LONGDESCRIPTION long_description] [FOLDER new_location_path] [REPORTDISPLAYFORMS (Form1 [, Form2 . . .[, FormN]]| NONE)] [BROWSEDISPLAYFORMS (Form1 [,Form2 . . .[, FormN]]| NONE)] [ELEMDISPLAY (LOCKED | UNLOCKED | LIMIT number_of_forms)] [SECFILTERSTOELEMBROWSING (TRUE | FALSE)] [ENABLEELEMCACHING (TRUE | FALSE)][MULTILINGUAL (TRUE | FALSE)] FOR PROJECT project_name;

where:

  • attr_name is the name of the attribute to be modified, of type string, between double quotes (").

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

  • new_attr_name is the new name of the attribute, of type string, between double quotes (").

  • new_desc is the new description of the attribute, of type string, between double quotes (").

  • long_description is the new long description of the attribute, of type string, between double quotes (").

  • new_location_path is the folder into which the attribute is to be moved, of type string, between double quotes (").

  • formN is the form to be displayed in a report, of type string, between double quotes (").

  • number_of_forms is the maximum number of forms, of type integer.

  • 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 ATTRIBUTE "Day" IN FOLDER "\Schema Objects\Attributes" NAME "Duplicate_Day" FOLDER "\Schema Objects\Attributes\Time" REPORTDISPLAYFORMS "ID" BROWSEDISPLAYFORMS "ID" ELEMDISPLAY UNLOCKED SECFILTERSTOELEMBROWSING TRUE ENABLEELEMCACHING TRUE FOR PROJECT "MicroStrategy Tutorial";