Types of prompts

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

This type of prompt allows users to determine how the report’s data is filtered, based on attributes in a hierarchy, lists of attribute elements, or metrics.

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.

 

Attribute Element List Prompt

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.

 

Metric Qualification Prompt

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.

Object Prompt

 

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.

 

Value prompts

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 Advanced Reporting Guide.

Related topics