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

KB31919: How to set the selector to only show particular attribute forms in MicroStrategy Web?


Community Admin

• Strategy


How to set the selector to only show particular attribute forms in MicroStrategy Web?

A selector allows users to filter data by particular elements. However, attributes may have multiple forms that are useful for displaying on a grid but not in a selector. For example, it may make sense to display both Customer First Name and Customer Last Name on a grid, but developers may wish to only display Customer Last Name in the selector.
 
Follow the steps below to display the ID and DESC forms of an attribute on the grid but only the DESC form in the selector in the Strategy Tutorial Project.
 

ka04W000000OhJMQA0_0EM440000002878.jpeg

 
 
 
 

ka04W000000OhJMQA0_0EM44000000287L.jpeg

 
 

ka04W000000OhJMQA0_0EM440000002876.jpeg

 
 

  1. In Strategy Developer 9.x, open the Attribute Editor and choose only the DESC form as the display form. In the example below, the Category attribute is shown:
  2. In Strategy Web 9.x, create a report with this attribute and add this report as a dataset to a document.
  3. Create a selector using this attribute as the source in the document, like shown below:
  4. Right click on the attribute on the grid and select "ID" under "Attribute Forms", like shown below:
  5. Run the document in Interactive mode, like shown below:  
ka04W000000OhJMQA0_0EM44000000287R.jpeg

Notice that the selector only displays the DESC form while the grid displays both the ID and DESC forms.
 
Note: Create a duplicate attribute with the same definition and use the duplicate attribute to avoid the change of display forms merging to other grid reports. 


Comment

0 comments

Details

Knowledge Article

Published:

May 25, 2017

Last Updated:

May 25, 2017