MicroStrategy ONE

Types of Prompts

Using the following prompt types, you can create a prompt for nearly every part of a report. It is important to remember that prompts can be used in many objects including reports, filters, metrics, and custom groups. All of these prompts will reveal themselves at report execution time, but the origin of the prompt can be within any of the objects.

  • The filter definition prompt encompasses four different prompt types, all of which allow the user to define the filtering criteria: attributes in a hierarchy, attribute forms, attribute element lists, and metrics.
  • An object prompt allows you to select which MicroStrategy objects to include in a report, such as attributes, metrics, custom groups and so on. Object prompts can either determine the definition of the report template or the report filter.
  • A value prompt allows you to select a single value such as a date, a specific number, or a specific text string. The value chosen by the user is compared to metric or attribute element values, and thus determines the data viewed by the user.

    Prompts can also be used as part of a function expression, and value prompts are particularly suited to provide values for function arguments. For a description of how to use prompts in function expressions, see the Functions Reference.

  • A level prompt allows you to specify the level of calculation for a metric.

    This section provides merely a basic review of all these types, with the exception of level prompts. For details, examples, and procedures, see the Building Query Objects and Queries, for Designers chapter of the Basic Reporting Help. The MicroStrategy Developer help also contains detailed procedures to create the various types of prompts.

    You can also create prompts for use with MicroStrategy Mobile. For examples and steps, see the MicroStrategy Mobile Administration Help.