Defining Cube Hierarchy Properties
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.
Property
Description
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:
Value
Description
FullyOptimizedThe instance builds indexes for the hierarchy to improve query performance. This is the default value.
NotOptimizedThe instance does not build additional indexes.
Visible
Determines the visibility of the cube hierarchy. The default value is True.