Sdílet prostřednictvím


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.

See Also

Concepts