MicroStrategy ONE

Report Viewer menu bar options: View menu

The following View menu options are specific to the Report Viewer:

Available to users with Developer  privileges, this view displays the structure of a report (that is, the headers for the report template components) without the values returned from your data source. When you select Design View, the report is opened in the Report Editor.

  • Grid view: Displays a report in a typical spreadsheet layout, with rows and columns.

  • Graph view: Displays a report as a graph. Notice that the Gallery menu becomes available when this view is selected. The Graph menu also appears, for Developers.

  • SQL view: Displays the SQL statement that is submitted to your data warehouse when the report is executed, as well as some statistical information for the report (number of rows, execution time, and so on).

  • Report Objects: You must have the MicroStrategy OLAP Services product to see the Report Objects pane. This menu option displays or hides the Report Objects pane where you can see all objects that are part of the report. You can drag and drop objects from a report to this area, to remove them from the current calculation of report results but retain them for later re-use on the report. Likewise, you can take objects from the Report Objects pane and add them to the report by dragging and dropping. When objects are added to or removed from the report to the Report Objects pane, the report results dynamically recalculate to accommodate the addition or removal of the object.

  • Report Details: Displays a pane above the report showing the report's description, its filter definition, whether any report limits are applied, and whether cached data was accessed when the report was executed.

  • View Filter: Available in Grid and Design views only. You must own the MicroStrategy OLAP Services product to see the View Filter pane. This option displays or hides the View Filter pane above the report. Use the View Filter pane to dynamically apply new filtering conditions to the report, to filter the report results. From this pane, you can also dynamically rerun a report. The View Filter window provides the following dynamic redefinition capabilities:

    • New lets you define new filtering criteria to filter your report results.

    • Clear removes a view filter qualification.

    • Apply redisplays the report showing new report results based on your new qualification.

    • Auto-Apply changes redisplays the report automatically so you do not have to click Apply. This is useful when you are creating or changing multiple qualifications.

  • Page-by: Displays or hides the pane where page names are shown when the Page-by functionality is applied to a report. For an introduction to page-by, see Grouping report data: Page-by.

  • Toolbar: Displays the various toolbars at the top of the screen for quick access. A toolbar contains icons for tasks you commonly perform. For example, the View toolbar displays icons for all of the options available on the View menu. Each of the toolbars is displayed or hidden by clicking its name in the list.