Toolbar (Cube Structure Tab, Cube Designer) (SSAS)

Use the Toolbar pane to perform common actions, such as processing or creating new measure groups, on the Cube Structure tab in Cube Designer.

Options

Term

Definition

Add Business Intelligence

Click to display the Business Intelligence Wizard and add business intelligence features to the cube. For more information about the Business Intelligence Wizard, see Business Intelligence Wizard F1 Help (SSAS).

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

New Measure

Click to display the New Measure dialog box and add a new measure to the measure group currently selected in the Measures pane. For more information about the New Measure dialog box, see New Measure Dialog Box (SSAS).

New Measure Group

Click to display the New Measure Group dialog box and add a new measure group to the Measures pane. For more information about the New Measure Group dialog box, see New Measure Group Dialog Box (Cube Designer).

Show Measures

Click to cycle through the following options, or select one of the following options to change the view of the Measures pane:

Option

Definition

TreeDisplay measure groups and measures in a tree view.

GridDisplay measure groups and measures in a grid.

Add Cube Dimension

Click to display the Add Cube Dimension dialog box and add references to existing or new database dimensions in the cube. For more information about the Add Cube Dimension dialog box, see Add Cube Dimension Dialog Box (SSAS).

New Linked Object

Click to display the Linked Object Wizard and link measure groups and dimensions from other cubes, and to import actions, KPIs, and calculations, to the selected cube. For more information about the Linked Object Wizard, see Linked Object Wizard F1 Help (SSAS).

Delete

Click to display the Delete Objects dialog box and delete the selected objects in the Measures or Dimensions pane. For more information about the Delete Objects dialog box, see Delete objects and files Dialog Box (Analysis Services).

Move Up

Click to move the item selected in the Measures or Dimensions pane up one place.

ms187010.note(en-US,SQL.90).gifNote:

This option is disabled if the selected item cannot be moved up.

Move Down

Click to move the item selected in the Measures or Dimensions pane down one place.

ms187010.note(en-US,SQL.90).gifNote:

This option is disabled if the selected item cannot be moved down.

Show Table

Click to display the Show Table dialog box and display a table from the data source view associated with the cube in the Data Source View pane. For more information about the Show Table dialog box, see Show Table Dialog Box (SSAS).

Hide Table

Click to hide the selected table in the Data Source View pane.

ms187010.note(en-US,SQL.90).gifNote:

This option is disabled if a table is not selected in the Data Source View pane.

Find Table

Click to display the Find Table dialog box and find a table in the Data Source View pane. For more information about the Find Table dialog box, see Find Table Dialog Box (SSAS).

Zoom

Click to cycle through the zoom percentage options, or to select an available zoom percentage option, for the Data Source View pane.

Show

Click to cycle through the following options, or to select one of the following options to change the view of the Data Source View pane:

Option

Definition

Tree ViewDisplay tables, named queries, columns, named calculations, and relationships in a tree view.

Diagram ViewDisplay tables, named queries, columns, named calculations, and relationships in a database diagram.

See Also

Reference

Cube Structure (Cube Designer) (SSAS)
Measures (Cube Structure Tab, Cube Designer) (SSAS)
Dimensions (Cube Structure Tab, Cube Designer) (SSAS)
Data Source View (Cube Structure Tab, Cube Designer) (SSAS)

Other Resources

Cubes (Analysis Services)
Defining and Configuring Cubes and Cube Properties

Help and Information

Getting SQL Server 2005 Assistance