KB8481: How to create a prompt that allows text entries in MicroStrategy Developer

To create a prompt that allows users to enter text, perform the following steps:
 

• Open the Filter Editor and select the 'Add an Attribute qualification' radio button. Then, click 'OK'.
  

• Select an attribute to place in the 'Attribute' box by clicking the browse button.
• Select "DESC" from the 'Qualify On' drop down options and change the operator to "Contains", as shown below:
  

• Click the Single Prompt button in the Operator field or change "Value" in the drop down to "Single Prompt". The Prompt Generation Wizard will then appear.
• Give the prompt a default value and a minimum and maximum text length value, as shown in the example below:
  

•  
  Click on the 'Next' button.
   
  
• Add a title and description and click 'Finish' to complete the filter.
  

• Save the filter and add it to a report.

Now, when executing the report, the prompt will ask the user to input a text string. The engine will use the text string to find all attributes that have that text within its description.