MicroStrategy ONE

Interaction of Report Details Preferences and Prompt Details for Reports

Ensure that the report details preferences are disabled, which allows the report details settings to be used instead. For more information on report details preferences, see Enabling and Customizing Report Details Preferences.

You can disable the report details preferences when you save changes to the report details settings (as described in the following procedure) or by using the Developer Preferences dialog box (for steps, see Interaction of Report Details Preferences and Report Details for Reports).

If you do not disable the report details preferences, they override some of the report details settings that deal with the content of the report details. These include 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.

To Configure the Prompt Details for a Project

  1. Disable the report details preferences. For steps, see Interaction of Report Details Preferences and Report Details for Reports.
  2. In MicroStrategy Developer, right-click the project that you want to work with, and select Project Configuration.
  3. In the Categories list, expand Project definition, and select Document and Reports.
  4. Click Report details and properties.
  5. Select the Prompt Details check box.
  6. To determine whether 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.

  7. 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:
    • Default
    • Blank
    • Prompt Not Answered
    • No Selection
    • All/None
  8. 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:
    • Select Yes to show the attribute names.
    • Select No to omit the attribute names.
    • Select Repeated to repeat the attribute name for each prompt answer.
  9. Select the Include unused prompts check box to include unused prompts. Clear the check box if you do not want to include unused prompts. An unused prompt occurs when you drill on a report that contains a prompt. The drilled-to report can display or omit the prompt details from the drilled-from report.
  10. Click OK.

To Configure the Prompt Details for a Report

  1. Disable the report details preferences. For steps, see Interaction of Report Details Preferences and Report Details for Reports.
  2. Open the report. You can either edit it or execute it.
  3. Choose Data > Report Details Properties.
  4. Click the General tab.
  5. Ensure that prompt details are displayed by setting Prompt Details to Yes.

    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.

  6. To determine whether 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.

  7. 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
  8. 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:
    • Select Yes to show the attribute names.
    • Select No to omit the attribute names.
    • Select Repeated To repeat the attribute name for each prompt answer.
  9. 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.
  10. Click OK.
  11. 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 Prompt Details for Reports.
    • Click Yes to disable report details preferences. The changes that you made affect the display of prompt details in this report, and report details preferences are disabled for all reports.
    • Click No to keep report details preferences enabled. The report details preferences override the changes that you made.