Skip Navigation
Online help
PROMPTS


What is the purpose of a prompt?
Prompts allow you to defer any part of the report definition, such as the filter or template, until report execution, so that a single definition can fit a whole class of reports.

What different kinds of prompts are supported?
MicroStrategy Web supports the following prompt types:
  • Attribute Element List prompt allows you to select a list of attribute elements to use as part of the filter criteria in a report.
  • Attribute Qualification prompt allows you to specify a number of attribute qualifications that become part of the filter criteria in a report.
  • Metric Qualification prompt allows you to specify a number of metric qualifications that become part of the filter criteria in a report.
  • Hierarchical Attribute prompt allows you to specify conditions based on attributes and attribute elements selected from at least one hierarchy (a combination of an attribute element list prompt and an attribute form qualification prompt) to become part of the filter criteria in a report.
  • Value prompts allow you to specify a value of any data type, such as text, numeric, or date. If prompted for a date value, you can either type it in or select it from a calendar (if DHTML is on). To select a date from a calendar:
    • Click the calendar icon next to the prompt. A calendar appears. Click on a date to select it. To go to the next month, click the right arrow on the calendar. To go to the previous month, click the left arrow.
  • Object prompt allows you to select a set of objects to be placed on the template (attribute, metric, consolidation, template, or custom group) or filter(s) (or reports) to be used as the filter criteria in a report.
  • Level prompt allows you to specify at run time the level of calculation for a metric. For example, you could design a report that shows sales totals by time and allow the user running the report to choose whether the totals are at the year level, or at the month level, or at the week level, and so on.