MicroStrategy ONE

Configuring report prompt details

The report prompt details display the prompt information for all prompts in the report. You can configure:

  • Whether the prompt title and index (a number indicating the order of the prompts in the report) are displayed.

  • The text to display when a prompt is unanswered. The options are:

    • Display nothing

    • Display "Prompt Not Answered"

    • Display "No Selection"

    • Display "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.

  • Whether and how to display the attribute name for the attribute element list prompts. The options are:

    • Display the attribute name (for example, Region)

    • Omit the attribute name

    • Repeat the attribute name for each prompt answer (for example, Region = North, Region = South)

    The browse form of the attribute, which is displayed when a user answers the prompt, is used to display the attribute elements in the prompt details. For information on browse forms, see the Project Design Help.

  • 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 each of the properties listed above, you can instead choose to inherit the project-level report detail definition set in the Project Configuration Editor. For more information on the levels of inheritance, see Levels of report details configuration.

For examples of these settings, see the Advanced Reporting Help.

Interaction of report details preferences and report prompt details

The report details preferences specified in the Developer Preferences dialog box specify which types of report details are displayed. These preferences override some of the report details that are configured in the Report Details Properties dialog box in the Project Configuration Editor and in the Report Editor. The report details preferences specify whether the prompt details are displayed.

  • If the report details preferences specify that the prompt details are not displayed, you cannot display them using the Report Details Properties dialog box.

  • If the report details preferences specify that the prompt details are displayed, you cannot hide them using the Report Details Properties dialog box. You can use the Report Details Properties dialog box to configure how they are displayed, however.

You can change this behavior by disabling the report details preferences, allowing the report details properties to be used instead. You can disable the report details preferences when you save changes to the report details properties (as described in the following procedure) or by using the Developer Preferences dialog box (for instructions, see Disabling report details preferences). For more information about the report details preferences in general, and how to set them, see Enabling and customizing report details preferences.

To configure report prompt details

  1. Open the report to edit it or view it. How do I open the Report Editor? How do I open the Report Viewer?

  2. From the Data menu, select Report Details Properties. The Report Details Properties dialog box opens.

  3. Click the General tab.

    By default, each setting on this tab inherits the project setting, as described in Levels of report details configuration. You can return to this default by selecting <default> from the drop-down list.

  4. To ensure that the prompt details are displayed in the report, select Yes from the Prompt Details drop-down list.

  5. To determine whether or not to include the prompt titles and index, select Title and Index or No Title or Index from the Include Prompt Titles drop-down list.

    The prompt title is defined when the prompt is created, and the index is a number indicating the order of the prompts in the report.

  6. To specify the text to display when a prompt is unanswered, select one of the following from the Replacement string for unanswered prompts drop-down list:

    • Blank

    • Prompt Not Answered

    • No Selection

    • All/None

  1. To specify whether and how to display the attribute name for any attribute element list prompts in the report, select one of the following options from the Show attribute name for Attribute Element Prompts drop-down list:

    • To show the attribute names, select Yes.

    • To omit the attribute names, select No.

    • To repeat the attribute name for each prompt answer, select Repeated.

  1. To specify whether or to not include unused prompts, select Yes or No from the Include unused prompts drop-down list. 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.

  2. Click OK to return to the report.

  3. If report details preferences are enabled, a message opens, indicating that some of your changes may not be applied to the report, as described in Interaction of report details preferences and report prompt details above.

    • To disable report details preferences, click Yes. The changes that you made affect the display of report prompt details in this report, and report details preferences are disabled for all reports.

    • To keep report details preferences enabled, click No. The report details preferences override the changes that you made.

Related topics