Name Description
New report Resets the application to the initial state so that a new query can be created.
Connection Sets a new connection to an analysis services cube.
Save report Saves a new or an existing report.
Open report Opens a saved report.
Field List and Drop Area Shows the list of dimensions, levels and measures for the cube selected in the connection panel. Aslo shows the drop area that has rows, columns, measures and filters sections. When building a query, the dimensions, levels and measures from the "Field List" need to be dragged into the panel.
Charts Show a number of charts for the report. The chart will be interactive if the drill down or expand mode is selected.
MDX Shows the underlying MDX statement for the selected query. One can "build", manually modify and then "execute" a statement. The MDX statement will not be saved if a query filter is selected.
Pivot Move dimensions on rows to columns and those on columns to rows.
Drill Down/Expand/Expand All Selects a navigational mode. Expand mode is enabled by default.
Filter Rows Filters rows based on a Filter Formula
Show Only Top Show Top number, Top percent, Sum of cells limit, Bottom number, Bottom Percent, Sum of cells limit.
Add Percent of Total to Measures Add Percent of Total, Percent of Filtered Result, Percent of Dimension, Percent of Parent
SparkLine Add a SparkLine.
Add Calculated Member Add a calculated field to measures.
Add Named Sets Add, change or delete named set from a report.
Themes Set a style theme for a report.
Conditional formatting Apply conditional formatting to cells that fall within a given value range
Options Sets report options such as show/hide empty items, rows and columns summary
Zoom Allows scaling of the result table before it is printed
Export Export the result table to Excel, PDF or HTML
Subscriptions Add Subscriptions. Available after report is saved.
Print Data Prints the result table and charts
Email Report Email application to an application user or to a specified email
Snapshot Create a report snapshot for a report. A report can have multiple report snapshots.
Break results into pages If a query returns too many rows, the query can be broken down into pages.