KB204240: Error " Searching for 'xxx' resulted in no matches " occurs when creating security filter with qualification on attribute form expression via MicroStrategy Analytics Command Manager 9.4.1

• Strategy

Error message ‘Searching for 'xxx' resulted in no matches.’ is seen when the user attempts to execution following script to create security filter with qualification on attribute form expression via MicroStrategy Analytics Command Manager 9.4.1

SYMPTOM:
Error message ‘Searching for 'xxx' resulted in no matches.’ is seen when the user attempts to execution following script to create security filter with qualification on attribute form expression via Strategy Analytics Command Manager 9.4.1, as shown below:


CREATE SECURITY FILTER"CategoryBook1"FOLDER"\Project Objects\MD Security Filters\"IN PROJECT"Strategy Tutorial"EXPRESSION "Category@DESC=Books";

And get the error message below:
(Searching for 'Books' resulted in no matches.) Task(s) execution completed with errors.

CAUSE:
The syntax to present the form expression is incorrect.

ACTION:
The non-number format strings for attribute form should be enclosed with ^”. The correct syntax should be as follows:


CREATE SECURITY FILTER"CategoryBooks"FOLDER"\Project Objects\MD Security Filters\"IN PROJECT"Strategy Tutorial"EXPRESSION "Category@DESC = ( ^"Books^")";

Comment

0 comments

Details

Knowledge Article

Published:

April 6, 2017

Last Updated:

April 6, 2017