MicroStrategy ONE

Prompted Filters: Asking for User Input for Filter Conditions

You can create filters that prompt you for answers when you run reports. These prompted filters allow a report to have a dynamic report definition, which can change with each query when the information in the prompt dialog box is altered.

In other words, a prompted qualification in a filter allows you to dynamically modify the contents of a report at run time. (Recall that a filter is composed of at least one qualification.) By applying certain conditions on one or more of the attributes, attribute elements, metrics, or other objects that a report can include, it is possible to:

  • Apply conditions or modify components in a report at run time, eliminating the need for preliminary definitions
  • Execute a report multiple times, selecting a different answer to a given prompt each time, and have, as result, a set of immediate answers to compare

Most types of qualifications allow prompts. For more information on each, see:

For more information on prompts, see Advanced Prompts: Enabling User Input.