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
.gif "ms189650.note(en-US,SQL.90).gif")
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