MicroStrategy ONE

Prompt order in documents

By default, if multiple datasets are used on the document:

  1. The prompts in the first dataset are displayed to the user, then the second, and so on.

  2. If a prompt is contained in more than one report, the prompt is displayed on the first dataset only.

Within each dataset, an ordered list of prompts is constructed using the following rules:

  1. All non-prompt application objects (attributes, metrics, and so on) are ordered so that each object appears before its dependents.

  2. Each object is replaced with any prompts that it contains.

  3. If a prompt contains prompts, those prompts are added to the list immediately above the original prompt. (Prompts within another prompt must be answered before the original prompt can be answered.)

  4. The previous step is repeated until each prompt in the report is listed.

  5. Any duplicated prompts are eliminated. Each prompt is displayed only one time, and when it first occurs on this list of prompt.

If prompts are moved within the report filter after the report is first saved, the prompt order is not changed. The order that the prompts are initially saved is used for the default prompt order.

If the order of the reports in a document is changed, even after the document is first saved, the prompt order is affected. The prompts in the first dataset are displayed to the user, and then the second, and so on.

Changing the prompt order

You can change the order that prompts are presented when the document is executed. For example, your document contains datasets with Region and Call Center prompts, and you want to answer the prompts in that order. Use the Prompt Ordering dialog box in MicroStrategy Developer to specify that order.

To re-create this example, create the following before beginning the procedure:

  • A filter definition prompt on Region

  • A filter definition prompt on Call Center

  • A report with Region and the Revenue metric, filtered by the Region prompt

  • A report with Call Center and the Revenue metric, filtered by the Call Center prompt

  • A document including both reports as datasets, with Region, Call Center, and the Revenue metric in the Layout area

To order prompts in a document

  1. In MicroStrategy Developer, open the document in Design View in the Document Editor.

    To re-create the example, open the document including both reports as datasets.

  2. From the Data menu, choose Prompt Ordering. The Prompt Ordering dialog box opens.

  3. Select the prompt to modify and click the up or down arrows to change its order.

  4. Once the prompts are in the correct order (for the example, the order is Region and Call Center), click OK to return to the Document Editor.

    When you execute the document, the prompts are displayed in the order selected.