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

KB45542: It is not possible to get the "Remove related report filter elements" option unchecked in bulk for all metrics of a given project in MicroStrategy Desktop 9.2.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This technical note describes a limitation when trying to uncheck the 'Remove related report filter elements' condition advanced option in the metric editor and it's limited to MicroStrategy Developer 9.2.x.

SUMMARY
This technical note describes a limitation when trying to uncheck the 'Remove related report filter elements' condition advanced option in the metric editor and it's limited to Strategy Developer 9.2.x. No workaround is available although a solution/code fix of a new feature has been implemented and is available in Strategy Command Manager 9.3.x and higher versions.
SYMPTOM
In the metric editor, under Condition > Advanced... > Condition advanced options it is not possible to uncheck the 'Remove related report filter elements' option in bulk for all the metrics in a given project in Strategy Developer  9.2.x as in the screen shot below:

ka02R000000kcUaQAI_0EM440000002CP5.png

 
 
CAUSE
This is working by design and currently the only way of unchecking the 'Remove related report filter elements' option in Strategy Developer 9.2.x is by doing it manually, metric by metric.
ACTION
An enhancement has been implemented in Strategy 9.3.x. Upgrade to this version to take advantage of the new feature.
 
In Strategy Command Manager 9.3.x the parameter "REMOVEREPORTFILTERELEMENTS" has been implemented to allow unchecking the metric option 'Remove related report filter elements' in bulk. Follow the steps below in order to create a script that will automate this task:
1. In Strategy Command Manager 9.3.x go to menu Edit > Insert / Search Objects > Outlines > Metrics_Outlines.
2. Insert the Alter_Metric_Outline outline and edit as necessary so it looks like the script sample below:

ka02R000000kcUaQAI_0EM440000002CPG.png

 


ALTER METRIC "Cost" IN FOLDER "\Public Objects\Metrics\Sales Metrics" REMOVEREPORTFILTERELEMENTS FALSE FOR PROJECT "Strategy Tutorial";

 
3. Reconnect any open Developer session to reflect the latest change(s).
 
ADDITIONAL TROUBLESHOOTING
For a possible error message that may come up in case the Alter_Metric_Outlineis misconfigured, check the following technical note:
- KB18634: 'The token {token_name} within the expression has been found in more than one location' error occurs when running a script in Strategy Administrator - Command Manager 9.x.
 
For other issues related to Strategy Command Manager, provide following log files to Strategy Technical Support:
- DSSErrors.log
- CmdMgr.log
LEARN MORE
For further reference on Strategy Command Manager 9.3.x, check:
 
1. Strategy System Administration Guide 9.3.x product manual.
2. Command Manager on line Help (search for "REMOVEREPORTFILTERELEMENTS").
 


Comment

0 comments

Details

Knowledge Article

Published:

April 17, 2017

Last Updated:

April 17, 2017