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

KB38036: Selectors that allow multiple selections and have the "Apply filter as selector" disabled will show duplicate rows in MicroStrategy Web 9.x.


Community Admin

• Strategy


SYMPTOM:
When a grid is targeted by a selector that allows multiple selections and that has the "Apply filter as selector" option disabled, a user will see multiple rows appear in the grid. One row will appear per each selection made on the selector.
This behavior persists across all modes.
STEPS TO REPRODUCE:
It is possible to reproduce this issue in the Tutorial project by taking the steps as outlined below: 
 

  • Create a report with Year, Category, Subcategory, and Revenue. Only include Subcategory and Revenue in the template, like shown below.
     
ka04W000000OhnuQAC_0EM4400000027QQ.jpeg
  • Incorporate this report as a dataset for a new document.
  • Add a check-box selector on the Year attribute targeting the grid.
  • In the selector properties, uncheck the "Apply selectors as a filter" box, like shown below.
     
ka04W000000OhnuQAC_0EM4400000027QN.jpeg
  • Select multiple years on the Year selector and note that the Subcategory is listed on multiple rows in the grid:
     
ka04W000000OhnuQAC_0EM4400000027QR.jpeg

CAUSE:
This is working as designed. The duplicated rows are not actual repeated rows, but different rows for the same Subcategory that correspond to different Years. When a selector is being used as a slicer and not as a filter, the calculation of the metric values is only done once, prior to the display of the document. A slicer selector has no way of knowing that multiple selections will be done, thus cannot aggregate the different combinations on the fly. A filter selector makes a new trip or request to the IServer for the data thus being able to aggregate the new combination of selections. Refer to tech note KB17761 for more information. 
 
WORKAROUND:
For aggregation of multiple selections enable "Apply filter as selector".
To identify visually that each row corresponds to a different selection, add the attribute in the selector to the grid's template.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

April 13, 2017

Last Updated:

April 13, 2017