MicroStrategy ONE

Alter Security Filter statement

Modifies an existing security filter.

Copy 
ALTER SECURITY FILTER "security_filter_name" 
 DESCRIPTION "new_description" LONGDESCRIPTION "new_long_description" [FOLDER "location_path"] [HIDDEN (TRUE | FALSE)] IN [PROJECT] "project_name" [NAME "new_security_filter_name"] [(FILTER "new_filter_name" [IN FOLDER "filter_location_path"]| EXPRESSION "new_expression")] [LOCATION "new_location_path"] [TOP ATTRIBUTE LIST "new_top_attribute_name1" 
 [, ... "new_top_attribute_nameN"]] [BOTTOM ATTRIBUTE LIST "new_bottom_attribute_name1" [, ... "new_bottom_attribute_nameN"]];

where:

  • SECURITY FILTER "security_filter_name" is the name of the security filter to be altered, of type string.

  • DESCRIPTION "new_description" is the new description of the security filter, of type string

  • LONGDESCRIPTION "new_long_description" is the new description of the security filter, of type string

  • FOLDER "location path" is the location of the security filter, of type string.

  • HIDDEN indicates whether the security filter is hidden.

  • PROJECT "project_name" is the name of the project in which the security filter to be altered exists, of type string.

  • NAME "new_security_filter_name" is the new name for the security filter, of type string.

  • FILTER "new_filter_name" is the name of the new filter to provide the filtering expression, of type string.

  • FOLDER "filter_location_path" is the folder path where the filter to be used in the security filter is located, of type string.

  • EXPRESSION "new_expression" is the new expression of the security filter, of type string.

  • LOCATION "new_location_path" is the new folder path where the security filter is to be placed, of type string.

  • TOP ATTRIBUTE LIST "new_top_attribute_name1..N" is the name of a new attribute to be included in the top attribute list of the security filter, of type string.

  • BOTTOM ATTRIBUTE LIST "new_bottom_attribute_name1..N" is the name of a new attribute to be included in the bottom attribute list of the security filter, of type string.

Example

Copy 
ALTER SECURITY 
 FILTER "SecFilter1" IN "MicroStrategy Tutorial" FILTER 
 "Not On Promotion";