MicroStrategy ONE
Prompted filters: Asking for user input for filter conditions
Before you begin
You should be familiar with filters (which contain at least one qualification) and prompts. For background information, see About filters, Types of qualifications, and About prompts.
You can create filters that prompt users for answers when they 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.
A prompted qualification in a filter allows you to dynamically modify the contents of a report at run time. 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, thus eliminating the need for preliminary definitions
-
Execute a report multiple times, selecting a different answer to a given prompt each time, and have, as a result, a set of immediate answers to compare
Most types of qualifications allow prompts. Use the following links for steps to create a specific type of prompted qualification:
-
Prompted attribute qualifications (attribute qualifications filter on an attribute's form (ID, description, and so on) or on elements of the attribute)
-
Prompted metric qualifications (metric qualifications create a set of attributes based on the metrics associated with those attributes)
-
Report object prompts (using shortcut-to-a-report qualifications, which use the dataset of one report as a filter inside another report)
-
Filter object prompts (using shortcut-to-a-filter qualifications, which use an existing filter, either as is or with additional conditions, on a report)
Prompted qualifications can also be used in custom groups.