Define Cube Hierarchy Properties

Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium

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:

The instance builds indexes for the hierarchy to improve query performance. This is the default value.

The instance does not build additional indexes.
Visible Determines the visibility of the cube hierarchy. The default value is True.

See Also

User Hierarchies