MicroStrategy ONE

Create Filter statement

Creates a filter within an existing project.

Copy 
CREATE 
 FILTERfilter_nameIN [FOLDER]location_pathEXPRESSIONexpression[DESCRIPTIONdescription][LONGDESCRIPTIONlong_description][HIDDEN (TRUE 
 | FALSE)] ON PROJECTproject_name;

where:

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

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

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

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

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

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

This statement can only be executed in a Windows environment.

Examples

Copy 
CREATE 
 FILTER "West Region" IN FOLDER "\Public Objects\Filters" 
 EXPRESSION "Region@ID=1" ON PROJECT "MicroStrategy Tutorial";
Copy 
CREATE FILTER 
 "West Region" IN FOLDER "\Public Objects\Filters" 
 EXPRESSION "[\Schema Objects\Attributes\Geography\Region]@ID=1 
 ON PROJECT MicroStrategy Tutorial;
Copy 
CREATE 
 FILTER "RegionNorthEast 
 IN FOLDER \Public Objects\Filters EXPRESSION
Copy 
CREATE 
 FILTER "On Promotion(CM)" IN FOLDER "\Public Objects\Filters" 
 EXPRESSION "Promotion@DESC in ("Valentine's Day", "Summer 
 Fun")" ON PROJECT "MicroStrategy Tutorial";