TechNet
Export (0) Print
Expand All

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.

PropertyDescription
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:

 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.
VisibleDetermines the visibility of the cube hierarchy. The default value is True.

User Hierarchies

Community Additions

ADD
Show:
© 2016 Microsoft