Use the Add Cube Dimension dialog box in SQL Server Data Tools (SSDT) to add a reference to a database dimension to a cube. You can display the Add Cube Dimension dialog box by doing one of the following:

Click Add Cube Dimension in the Toolbar pane on the Cube Structure or Dimension Usage tab in Cube Designer.

Right-click the Dimensions pane on the Cube Structure tab in Cube Designer and select Add Cube Dimension from the context menu.

Right-click the Grid pane on the Dimension Usage tab in Cube Designer and select Add Cube Dimension from the context menu.

Note

Each cube dimension can have only one relationship to a measure group. However, you can create more than one cube dimension and add it to the cube, if the database dimension on which the cube dimension is based is related to measure groups through more than one relationship in the data source view. Such dimensions are referred to as role-playing dimensions and commonly occur with time dimensions.