Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/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: 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. |