MicroStrategy ONE
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
|
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, up to 15 digits, which is then used as part of a filter or within a metric, to look for specific numeric data. If a user enters more than 15 digits for a numeric prompt, the data is converted to scientific notation. If precision is needed beyond 15 digits, you should use a Big Decimal value prompt instead. |
|
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. |
The above prompts and level prompts are supported in Library Web. 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 Developer. For details on level prompts, see the Advanced Prompts chapter of the Advanced Reporting Help.
Related Topics
Hierarchy Qualification Prompt
Attribute Qualification Prompt
How to Create a Metric Qualification Prompt