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:

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: