Toolbar (Browser Tab, Cube Designer) (SSAS)
Use the Toolbar pane to perform common operations on the Calculations tab in Cube Designer.
Options
Option
Description
Process
Click to display the Process dialog box and process the cube. For more information about the Process dialog box, see Process Dialog Box (SSAS).
Change User
Click to display the Security Context dialog box and change the user and role used on the Browser tab. For more information about the Security Context dialog box, see Security Context Dialog Box (SSAS).
Reconnect
Click to reconnect the Calculations tab to the Analysis Services instance and database that contains the cube, if the session for the Browser tab is disconnected due to connection loss or timeout.
Refresh
Click to refresh the Metadata and Reports panes.
Sort Ascending
Click to sort the siblings of the selected row in the Report pane in ascending order for the language specified in Language.
Note This option is enabled only if a cell in the Reports pane is selected.
Sort Descending
Click to sort the siblings of the selected row in the Report pane in descending order for the language specified in Language.
.gif "ms188087.note(en-US,SQL.90).gif")
Note:
This option is enabled only if a cell in the Reports pane is selected.
Auto Filter
Click to automatically filter the results in the Result pane.
Show Only Top/Bottom
Select a value or percentage to show only the topmost or bottommost number or percentage of cells in the Report pane based on the selected measure.
For more information about this option, see TopCount (MDX), TopPercent (MDX), BottomCount (MDX), and BottomPercent (MDX).
Subtotal
Click to display subtotals.
All Item Totals
Click to display the totals for All members in the Report pane.
Show Empty Cells
Click to display empty cells in the Report pane.
Clear Results
Click to clear the results in the Report pane.
Commands and Options
Click to display the Commands and Options dialog box and edit advanced properties for the Microsoft Office 11.0 PivotTable control in the Report pane. For more information about the Commands and Options dialog box, see the Microsoft Office documentation.
Perspective
Select the perspective from which to view data and metadata in the Metadata and Report panes.
To view the cube without using a perspective, select the cube name.
Language
Select the language with which to view data and metadata in the Metadata and Report panes.
To view the cube using the default language, select Default.
See Also
Reference
Browser (Cube Designer) (SSAS)
Report (Browser Tab, Cube Designer) (SSAS)
Metadata (Browser Tab, Cube Designer) (SSAS)
Subcube (Browser Tab, Cube Designer) (SSAS)