MicroStrategy ONE

  • Setting page-by save options

The Advanced tab allows you to retain the page-by settings on a report template when you save the report. It also allows you to save any modifications that you make to a prompted report, after executing that report.

Page-by enables you to select and display subsets of your report data as separate pages. For example, a report shows sales and profit data organized by country. You can page by country to see data for only one country at a time. The Advanced tab allows you to retain the page-by settings when you save the report.

The check box When saving a report to be reprompted, rerun prompt included in objects in the report definition allows you to retain the modifications that you make to a prompted report template after you execute that report.

For example, you create a prompted report that displays the revenue for selected regions. After you execute the report you add the attribute Year to the report and select a new auto style for the report. If you want these changes to be saved on the report template, you should clear this check box before making the changes, whereas if you do not want these changes to be saved on the report template you should select this check box before making the changes.

To set page-by options

  1. Open the Report Editor. (How?)

  2. From the Data menu, choose Report Data Options. The Report Data Options dialog box opens.

  3. Under Categories, expand General, and then select Advanced. General - Advanced appears on the right side of the editor.

  4. Select whether to clear or retain page-by elements when the report is saved:

    • Default uses the project-level setting.
    • Yes clears the page-by elements when the report is saved, overriding the project-level setting.
    • No retains the page-by elements when the report is saved, overriding the project-level setting.

  5. Select the When saving a report to be reprompted, rerun prompt included in objects in the report definition check box if you do not want to retain the changes that you have made to a prompted report after executing the report.

  6. Click OK.

Related Topics