A cube dimension is an instance of a database dimension within a cube. Cube dimension are accessible inside that particular cube, We can’t access one cube dimension in another cube. Please refer Create Dimension in SSAS article to understand, How to create Database Dimension in SQL Server Analysis Services.
Create Cube Dimension in SSAS
In this example we are going to show you, How to Create Cube Dimension in SQL Server Analysis Services 2014.
STEP 1: Within the Dimension Pane, Right click on the Cube Name will open the Context Menu to choose the options. Since we are adding the Cube dimensions click on the Add cube dimension option
Clicking on the Add cube dimension option will open the Add Cube Dimension window and the windows will show us all the available Dimension Tables in the Data Source View.
From this windows we have to select the required dimension as per your organization requirements.
From the above screenshot you can observe that we have selected all the tables present in the Data Source View. Click ok to close the window.
From the above screenshot we have to understand that, All the Dimensions present in the Dimensions Pane are called as Cube Dimensions and all the Dimensions present in the solution explorer are called as Database Dimensions.
Thank you for Visiting Our Blog