The correct prompt type to create depends on what report objects you want users to be able to base a filter on to filter report data.
Prompt type |
Prompt name |
What Data It Allows Users to Define
|
Filter definition prompts |
Hierarchy Qualification Prompt Prompts users to choose from all attributes in a hierarchy |
Users can select prompt answers from one or more attribute elements from one or more attributes. The attribute elements that they select are used to filter data displayed on the report. This prompt lets you give users the largest number of attribute elements to choose from when they answer the prompt to define their filtering criteria. For example, on a report displaying profit forecasts, if the prompt lets users select from the Product hierarchy, one user might choose to see forecasts for certain electronic products, while another user might select different electronics products, or all media products. |
Attribute Qualification Prompt Prompts users to qualify on an attribute |
Users can select prompt answers from a list of attribute elements from a single attribute. This prompt is more restrictive than the hierarchy qualification prompt, because the user has fewer attribute elements to select answers from.
| |
Prompts users to choose from an attribute element list |
Users can select prompt answers from a limited list of specific attribute elements. This prompt is the most restrictive of the filter definition prompts, because the user has the least number of attribute elements to select answers from.
| |
Prompts users to qualify on a metric |
Users can define a metric qualification, which determines what data should be displayed for one or more specific metrics on the report.
| |
Object prompts This type of prompt allows users to select objects to include in a report, such as attributes, metrics, or filters. |
|
Users can use this prompt to add more data to a report. Users select objects (such as attributes or metrics) that they want to add to the report. Users can also choose from among a selection of filters, to apply a filter that is most useful for their analysis purposes.
|
This prompt type lets users select a single value, such as a date or a specific text string, and filter report data based on their selection.
|
Date & Time prompt |
Users select a specific date and time for which to see data. This prompt is used in a filter. |
Numeric prompt |
Users enter a specific number, which is then used as part of a filter or within a metric, to look for specific numeric data. | |
Text prompt |
Users enter a word or phrase, which is then used as part of a filter to look for specific data with that text. | |
Big Decimal prompt |
Users can enter up to 38 digits, to search for numeric data with the Big Decimal data type assigned to it. |
Level prompts allow users to specify the level of calculation for a metric. Level prompts cannot be created from MicroStrategy Web; they must be created in MicroStrategy Desktop. For details on level prompts, see the Advanced Prompts chapter of the MicroStrategy Advanced Reporting Guide.
Related topics
Filtering data based on a related set of attributes: Hierarchy prompt
Filtering data based on an attribute form: Attribute element list prompts
Filtering data based on an attribute: Attribute qualification prompts
Filtering data based on a metric: Metric qualification prompts
Filtering data based on metrics, attributes, or other objects: Object prompts
Filtering data based on a single value or string: Value prompts