KB8274: How to create a filter that uses an attribute’s DESC form in the WHERE clause instead of the ID form in MicroStrategy Developer 9.x and 10.x

By design, the form that has been set as the attribute’s key is the form that is used in the ‘Where’ clause of the Structured Query Language (SQL) when qualifying on that attribute.
 

 
It is possible to qualify on a different form of the attribute. To achieve this, perform the following steps:
 

• Create a filter using an Attribute Qualification and select the attribute.
• Qualify on the DESC form.
• Choose the operator `In List`, as shown below:
  

•  
  NOTE: In the List window, users can import from a text file, enter values directly in the window (format: "item1", "item2", "item3", etc...) or use the Object Browser to drag the elements into the window.
   
  
• Save and close this filter.

When using this filter in a report and switching to SQL view, users will observe that the DESC form is used, as shown below: