MicroStrategy ONE
About adding a prompt to a filter's definition in the Filter Editor
A prompt is a question the system presents to a user during report execution. How the user answers the question determines what data is displayed on the report when the results are returned from your data source. Prompts are an effective way to design a single report that can support a broad user audience, since each user can designate the specific information that they want to see.
You can add almost any kind of prompt to a filter's definition in the Filter Editor. The following table lists requirements to add different prompt types to a filter definition.
Type of Prompt | Filter Definition Pane |
All filter definition prompts | Yes |
Object prompt of attributes | Added as part of an advanced qualification or the level of a set qualification |
Object prompt of metrics |
Added as part of a set qualification, and any place that accepts metrics |
Object prompt of filters | Yes |
Date prompt (value prompt) | Added as part of an attribute form qualification, on an attribute form of Date data type |
Numeric prompt, Long prompt, or Big Decimal prompt (value prompt) | Added as part of a set qualification, on an attribute form of a text data type |
Text prompt (value prompt) | Added as part of an attribute form qualification, on an attribute form of a text data type |
Level prompts | Cannot be used in filters |
Use one of the following procedures, depending on the type of prompt that you want to add to the filter:
-
Adding a filter definition prompt or an object prompt containing filters to a filter
-
Adding a Numeric prompt, Long prompt, or Big Decimal prompt to a filter
You can also create a prompt when you create a filter. This embedded prompt cannot be used in other filters or objects, but only in the filter that it was created in. For instructions to create an embedded prompt within a filter, see Prompted filters: Asking for user input for filter conditions.
For descriptions of the various types of prompts, including instructions to create them, see: