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

KB43016: Attribute elements are not sorted according to the "Browse sort" property of the attribute when creating an "In List" view filter in MicroStrategy Web


Community Admin

• Strategy


Attribute elements are not sorted according to the "Browse sort" property of the attribute when creating an "In List" view filter in MicroStrategy Web.

SYMPTOM:
View filters on reports can be of type "In List". This type of view filter will display the full list of attribute elements for the user to select for the filtering condition. In Strategy Developer 9.x, the list from the view filter can be sorted alphabetically ascending or descending by manipulating the attribute's "Browse sorting" property, like shown below:
 

ka04W000000Odi7QAC_0EM4400000026jp.png

 
However, in Strategy Web 9.x, the sorting for the view filter list does not seem to be affected by this property.
 
STEPS TO REPRODUCE:
Follow these steps in Strategy Tutorial 9.x to reproduce:

  • In Strategy Developer, edit the "Subcategory" attribute, highlight the "DESC" form, click "Modify", and set the browse sort to "Ascending", as shown below:
     
ka04W000000Odi7QAC_0EM4400000026jp.png
  • Click "OK", and then "Save and close". Update the Schema in Strategy Developer.
  • Still in Strategy Developer, create a new report with "Subcategory" in the rows, and run the report.
  • Add an "In List" attribute element view filter using "Subcategory", and notice the list of elements are sorted alphabetically, as shown below:
     
ka04W000000Odi7QAC_0EM4400000026jn.png
  • Run the same report in Strategy Web 9.x, create the same view filter, and notice that the elements are not sorted alphabetically, as shown below:
     
ka04W000000Odi7QAC_0EM4400000026jl.png

 
CAUSE:
This is a known issue in Strategy Web 9.x.
 
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.
 
WORKAROUND:
In the attribute editor in Strategy Developer 9.x, set the "Report sort" to "Ascending" as well. This will make the elements in the view filter in Strategy Web sort correctly.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 20, 2017

Last Updated:

June 20, 2017