Difference between Database Dimension and Cube Dimension in SSAS

12-06-2019  0 Comment(s)

In SQL Server Analysis Services, there are Two types of Dimensions

Database Dimension
Cube Dimension
Database Dimension in SSAS
All the dimensions that are created using the Dimension Wizard of the Solution Explorer are treated as database dimensions. In other words, the dimensions which are at Database level are called Database Dimensions.

Database dimensions are independent to the cubes so single Database dimension can be used in multiple cubes. Please refer Create Dimensions in SSAS article to understand, How to create Database Dimensions in SQL Server Analysis Services

From the above figure, all the dimensions such as Dim Customer, Dim Product etc.., which are placed under the Dimensions folder are Database Dimensions.

Cube Dimension in SSAS
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 cube dimension in another cube. Please refer Create Cube Dimension in SSAS article to understand, How to create Cube Dimensions in SQL Server Analysis Services.


Comment Here


No Comments to Show