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

KB18121: How to use attributes whose name's contain spaces as parameters for expressions in MicroStrategy Command Manager 9.x and 10.x scripts


Community Admin

• Strategy


How to use attributes whose name's contain spaces as parameters for expressions in MicroStrategy Command Manager 9.x and 10.x scripts

SYMPTOM:
While using Strategy Command Manager 9.x and 10.x scripts to create certain objects, Strategy Administrators receive the following error message when using an attribute whose name contains spaces as shown below::
 

ka04W000000OgkeQAC_0EM440000002BL4.jpeg

 
Searching for 'xxxx' resulted in no matches.Task(s) execution completed with errors.
STEPS TO REPRODUCE:
To reproduce the issue with Strategy Tutorial, an Administrative user can run the following Strategy Command Manager 8.x scripts:
 
CREATE SECURITY FILTER "Customer City" IN PROJECT "Duplicated Strategy Tutorial" EXPRESSION "Customer City@ID=1";
CREATE FILTER "Customer City" IN FOLDER "\Public Objects\Filters" EXPRESSION "Customer City@DESC in (#34;Dallas#34;,#34;Washington#34;)" ON PROJECT "Duplicated Strategy Tutorial";
CREATE METRIC "Count Customer City" IN FOLDER "\Public Objects\Metrics\Count Metrics" EXPRESSION "Count(Customer City) {Country} "<>" ON PROJECT "Duplicated Strategy Tutorial";
CAUSE:
Attribute names that contain spaces cannot simply be used in parameters such with the parametere EXPRESSION example above.
 
ACTION:
Enclose the attribute names that contain spaces with brackets , as shown below:
 

ka04W000000OgkeQAC_0EM440000002BL0.jpeg

 


Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

June 12, 2017