Cube hierarchy properties enable you to specify unique settings for user-defined hierarchies in cube dimensions based on the same database dimension. The following table describes the properties of a cube hierarchy.
|Enabled||Determines whether the hierarchy is enabled for the cube dimension.|
|HierarchyID||Contains the unique identifier (ID) of the hierarchy.|
|OptimizedState||Determines the level of optimization that is applied to the hierarchy. This property can have the following values:
The instance builds indexes for the hierarchy to improve query performance. This is the default value.
The instance does not build additional indexes.
|Visible||Determines the visibility of the cube hierarchy. The default value is True.|