KB47573: Unable to create filter using attribute IN LIST qualification based on DESC form via MicroStrategy Command Manager 9.4.x-10.x.

• Strategy

This knowledge base article explains why users may be unable to create filter using attribute IN LIST qualification based on DESC form via MicroStrategy Command Manager 9.4.x-10.x.

SYMPTOM:
In Command Manager, the user is unable to create filter to qualify on attribute using IN LIST qualification based on DESC form. Run the following script to create filter to qualify on DESC form of Category in Tutorial project via Command Manager, it returns error "Searching for 'Books' resulted in no matches."


CREATE FILTER "Category in Books&Music"  IN FOLDER "\Public Objects\Filters" EXPRESSION "@DESC IN (Books, Music)" ON PROJECT "Strategy Tutorial";


Error:
(Searching for 'Books' resulted in no matches.)
Task(s) execution completed with errors.

CAUSE:
The pattern of the attributes elements in brackets is incorrect.

ACTION:
Embrace the each attribute element with mark ^". So the correct script should be as below:


CREATE FILTER "Category in Books&Music" IN FOLDER "\Public Objects\Filters" EXPRESSION "@DESC IN (^"Books^",^" Music^")" ON PROJECT "Strategy Tutorial";

Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

June 7, 2017