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:
ValueDescription
FullyOptimized The instance builds indexes for the hierarchy to improve query performance. This is the default value.
NotOptimized The instance does not build additional indexes.
|
Visible |
Determines the visibility of the cube hierarchy. The default value is True. |