Define Cube Hierarchy Properties
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. |
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for