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

KB14989: An attribute element filter is not being applied but instead a view filter is created when drilling down on attribute elements in MicroStrategy Web 9.x


Community Admin

• Strategy


An attribute element filter is not being applied but instead a view filter is created when drilling down on attribute elements in MicroStrategy Web 9.x

SYMPTOM:
A user has created the following report executed through Strategy Web 9.x:
 

ka04W000000OcvsQAC_0EM4400000028qQ.jpeg

 
The user clicks on Region to drill down to the Call Center level for the Region 'Mid Atlantic'. Then the user chooses View -> View Filter and only wants to show one Call Center. Upon the drill menu appearing, the user notices two things illustrated below:
 

  • The available Call Centers for the Northeast Region do not match what is being displayed on the grid below.
  • There is currently a view filter applying a condition of Region = Northeast.
ka04W000000OcvsQAC_0EM4400000028qP.jpeg

CAUSE:
This is working by design. The Report Objects window contains the attribute Call Center, which the user was drilling on, as illustrated below. Therefore, so that a new report execution is not kicked off by changing the SQL and the OLAP Services report is taken advantage of, a simple view filter is applied to the report instead. This means that all of the available Call Centers in the report cache will be displayed as available to be filtered on. Other view filters do not get applied to attribute element lists for users to select from when defining a view filter.
 

ka04W000000OcvsQAC_0EM4400000028qX.jpeg

 
ACTION:
To make the elements available match only those on the grid report, remove the attribute that is being drilled to from the report.
 


Comment

0 comments

Details

Knowledge Article

Published:

June 24, 2017

Last Updated:

June 24, 2017