Define Cube Dimension Properties
A cube dimension is an instance of a database dimension within a cube. A database dimension can be used in multiple cubes, and multiple cube dimensions can be based on a single database dimension. The following table describes the properties of a cube dimension.
Controls how aggregations are designed by the Aggregation Designer in Microsoft SQL Server Analysis Services. This property can have the following values:
Provides a descriptive name for the level.
Contains the unique identifier (ID) of the database dimension.
Determines how unique names are generated for hierarchies that are contained within the cube dimension. This property can have the following values:
Contains the unique identifier of the cube dimension.
Determines how unique names are generated for members of hierarchies contained within the cube dimension. This property can have the following values:
Contains the friendly name of the cube dimension. By default, the name of a cube dimension is the same as the name of the database dimension, unless another cube dimension of the same name is already defined.
Determines whether the cube dimension is visible. The default value is True.