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. .gif "Note") 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