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

KB31739: When the view filter is empty for a report, the "Filter on Selections" option will place the element into the report filter instead in MicroStrategy Web


Community Admin

• Strategy


When the view filter is empty for a report, the "Filter on Selections" option will place the element into the report filter instead in MicroStrategy Web 9.x

SYMPTOM:
When the view filter is empty for a report, the 'filter on selections' will place the element into a report filter. However, if the view filter has an existing condition, the same option will place the element into the view filter of the report.
 
STEPS TO REPRODUCE:

  • In Strategy Tutorial, create a report with the Call Center attribute and Profit metric
  • Execute the report in Web.
  • Right click on any one of the call centers and select the option 'filter on selections'
     
     
ka04W000000OgLVQA0_0EM4400000028Bh.jpeg
  • Notice that the element been placed in the Report Filter section
     
ka04W000000OgLVQA0_0EM4400000028Bf.jpeg
  • Re-create a report with Call Center attribute and Profit metric. In the view filter section, insert a condition (eg: Profit > 0)
     
ka04W000000OgLVQA0_0EM4400000028Be.jpeg
  • Execute the report in Interactive mode.
  • Right click on any one of the call centers and select the option 'filter on selections'
  • Observe the element been placed in the View Filter section this time.
      

CAUSE:
This is working as designed. 'Filter on selections' adds the condition to the view filter if the report is an OLAP report. However, an OLAP report shouldn't be converted to a standard report as a result of this manipulation, so it will add the condition to the report filter if the report is a standard report.
 
For more information on requirements to add Filter on Selections conditions to the view filter please refer to TN: 42005 - "When is a filter condition added to the View Filter and when to the Report Filter after performing the "Filter on Selections" action in Strategy 9.x"
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017