MicroStrategy ONE

Create Security Filter statement

Creates a new security filter.

Copy 
CREATE SECURITY FILTER "security_filter_name" 
 [DESCRIPTION "description"] [LONGDESCRIPTION "long_description"] 
 [FOLDER "location_path"] [HIDDEN (TRUE | FALSE)] IN [PROJECT] "project_name" [(FILTER "filter_name" [IN FOLDER "filter_location_path"] | EXPRESSION "expression")] [TOP ATTRIBUTE LIST "top_attribute_name1" 
 [, ... "top_attribute_nameN"]] [BOTTOM ATTRIBUTE LIST "bottom_attribute_name1" 
 [, ...  "bottom_attribute_nameN"]];

where:

  • SECURITY FILTER "security_filter_name" is the name of the new security filter, of type string.

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

  • LONGDESCRIPTION "long_description" is the long description of the security filter, of type string.

  • FOLDER "location_path" is the folder path where the security filter is to be placed in the project, 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 is to be created, of type string.

  • FILTER "filter_name" is the name of the 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 "expression" is the text representation of a logical function, comparison (predicate) function or value calculation, of type string. For details on how to build expressions, see Filter qualification syntax.

    If you refer to an object within the expression and another object exists with the same name in a different folder in the project, Command Manager does not understand which object the expression refers to and returns an ambiguity error message. To resolve this, specify the full path of the object you are referring to, within the expression's brackets.

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

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

Examples

Copy 
CREATE 
 SECURITY FILTER "SecFilter1" IN PROJECT "MicroStrategy 
 Tutorial" FILTER "Eastern United States Customers" TOP 
 ATTRIBUTE LIST "Year" BOTTOM ATTRIBUTE LIST "Region", 
 "Salary";
Copy 
CREATE SECURITY FILTER "New Security Filter" 
 IN PROJECT "MicroStrategy Tutorial" FILTER "[\Public Objects\Filters\Eastern 
 United States Customers]" TOP ATTRIBUTE LIST "Year" BOTTOM 
 ATTRIBUTE LIST "Region";