Define Cube Attribute Properties
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
Cube attribute properties enable you to specify unique settings for dimension attributes in cube dimensions based on the same database dimension. The following table describes the properties of a cube attribute.
| Property | Description |
|---|---|
| AggregationUsage | Specifies how the Aggregation Design Wizard will design aggregations for the attribute. The default value is Default. This property can have the following values: Default: The Aggregation Design Wizard applies a default rule based on the type of attribute (Full for keys, Unrestricted for others). None: No aggregation for the cube should include this attribute. Unrestricted: No restrictions are placed on the Aggregation Design Wizard Full: Every aggregation for the cube must include this attribute. |
| AttributeHierarchyEnabled | Identifies whether the attribute hierarchy is enables on this cube dimension. This allows attribute hierarchies to be disabled on specific cubes or dimension roles. This setting has no effect if the underlying attribute hierarchy is disabled. Default value is True. |
| OptimizedState | Indicates whether the attribute hierarchy is optimized on this cube dimension. This allows attribute hierarchies to be optimized on specific cubes or dimension roles. This setting has no effect if the underlying attribute hierarchy is not optimized. The default value is FullyOptimized. 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. |
| AttributeHierarchyVisible | Indicates whether the attribute hierarchy is visible on this cube dimension. This allows attribute hierarchies to be visible on specific cubes or dimension roles. This setting has no effect if the underlying attribute hierarchy is not visible. The default value is True. |
| AttributeID | Contains the unique identifier (ID) of the attribute. |
See Also
Define Cube Dimension Properties
Define Cube Hierarchy Properties
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