Define Cube Hierarchy Properties


Applies To: SQL Server 2016

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.

EnabledDetermines whether the hierarchy is enabled for the cube dimension.
HierarchyIDContains the unique identifier (ID) of the hierarchy.
OptimizedStateDetermines 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.
VisibleDetermines the visibility of the cube hierarchy. The default value is True.

User Hierarchies

Community Additions