MicroStrategy ONE

Alter Filter statement

Modifies the properties of an existing filter within a project.

Copy 
ALTER FILTERfilter_nameIN [FOLDER]location_path[NAMEnew_filter_name] [EXPRESSIONnew_expression] [DESCRIPTIONnew_description][LONGDESCRIPTIONlong_description][LOCATIONnew_location_path] [HIDDEN (TRUE 
 | FALSE)] ON PROJECTproject_name;

where:

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

  • location_path is the folder path where the filter is located, of type string, between double quotes (" ").

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

  • new_expression is the new filter qualification, of type string, between double quotes (" "). For the syntax of filter qualifications in Command Manager, see Filter qualification syntax.

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

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

  • new_location_path is the new folder path where the filter will be moved, of type string, between double quotes (" ").

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

This statement can only be executed in a Windows environment.

Example

Copy 
ALTER 
 FILTER "West Region" IN "\Public Objects\Filters" 
 NAME "East Region" EXPRESSION "Region@ID=2" ON PROJECT 
 "MicroStrategy Tutorial";