EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB14101: How to create a ‘Not in list’ filter using MicroStrategy Administrator - Command Manager 9.x?


Community Admin

• Strategy


This knowledge base article explains how to create a "Not in List" filter using Command Manager outlines. 
In order to create a 'Not in list" filter using Strategy Administrator Command Manager 9.x, use the following syntax:


CREATE FILTER "" IN FOLDER "" EXPRESSION " ()" ON PROJECT "";

The following example shows how to create a filter on countries not in 'USA':

CREATE FILTER "Not in USA" IN FOLDER "\Public Objects\Filters" EXPRESSION "Country@ID (USA)"
ON PROJECT "Strategy Tutorial";

 


Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017