Grid (Dimension Usage Tab, Cube Designer) (SSAS)

Use the Grid pane on the Dimension Usage tab in Cube Designer to view and edit dimension relationships between cube dimensions and measure groups. Each dimension relationship is represented as a cell in a grid, in which measure groups are displayed as columns and dimensions are displayed as rows.

Options

Option	Definition
Measure Groups	Select the measure groups to display in the Grid pane as columns. Selecting (Show All) displays all of the available measure groups. Click a selected column header for a measure group to rename the measure group.
Dimensions	Select the cube dimensions to display in the Grid pane as rows. Selecting (Show All) displays all of the available cube dimensions. Click a selected row header for a dimension to rename the cube dimension.
(Cell)	Select a cell and click the ellipsis button (...) to display the Define Relationship dialog box and define a dimension relationship between a cube dimension and a measure group. For more information about the Define Relationship dialog box, see Define Relationship Dialog Box (Analysis Services).

Context Menu

The following options are available in the context menu, which is displayed by right-clicking the Grid pane:

Option

Definition

Add Cube Dimension

Select 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

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

Cut

Note:

This option is disabled.

Copy

Note:

This option is disabled.

Paste

Note:

This option is disabled.

Delete

Select to delete the selected cube dimension, measure group, or dimension relationship from the cube.

Rename

Select to rename the selected cube dimension, measure group, or dimension relationship.

Properties

Select to display the Properties window in Business Intelligence Development Studio for the selected cube dimension, measure group, or dimension relationship.

See Also

Reference

Dimension Usage (Cube Designer) (SSAS)
Toolbar (Dimension Usage Tab, Cube Designer) (SSAS)
Dimension Usage (Cube Designer) (SSAS)

Other Resources

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

Help and Information

Getting SQL Server 2005 Assistance