Share via


Toolbar (Browser Tab, Cube Designer) (Analysis Services - Multidimensional Data)

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 (Analysis Services - Multidimensional Data).

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 (Analysis Services - Multidimensional Data).

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.

NoteNote
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.