MicroStrategy ONE

Prompt Details: Examples

The Regional Revenue by Category report contains the Category and Region attributes, and the Revenue metric. It is prompted for Category and Region. The prompt details are configured to display the prompt titles and index. The prompt title is specified when the prompt is created (Category prompt and Region prompt in the example below), and the index is a number indicating the order of the prompts in the report (Prompt 1 and Prompt 2 below).

If you change the prompt details to omit the prompt titles and index, only the prompt answers are displayed, as shown below:

Both the Category and Region prompts are attribute element list prompts, so you can also specify whether and how to display the attribute name. In the example above, the attribute names are not displayed; only the selected attribute elements are listed. In the example below, the attribute names (Category and Region) are displayed.

You can select whether to display the attribute name once for each prompt, or, as shown above, repeated for each prompt answer.

The Category and Region prompts were answered in the previous examples, but sometimes users do not answer all the prompts. You can choose what to display when a prompt is not answered. You can select pre-defined text, or you can choose to display nothing at all. The pre-defined text includes:

  • Prompt Not Answered
  • No Selection
  • All/None

    Whether the word "All" or "None" displays depends on the type of prompt. For example, an unanswered object prompt displays as "None", because no objects are selected. An unanswered filter definition prompt displays as "All" because the report is not filtered and therefore all the objects appear on the report.

The following report sample is the same report as before, except that the Region prompt has been answered and the Category prompt has not. The prompt details for the Category prompt display the word "All," meaning that all the categories are included on the report.

Finally, you can choose whether to include unused prompts. An unused prompt occurs when you drill on a report that contains a prompt. The resulting child report can display or omit the prompt details from the parent.

For example, drill down from Region to Call Center on the previous report. The drilled-to report, as shown below, displays the prompt details of the drilled-from report (the original report). The unused prompts are included. If the original report instead did not include unused prompts, the Report Details pane would be blank.