Defining Cube Attribute Properties
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. This property can have the following values:
Value
Description
DefaultThe Aggregation Design Wizard applies a default rule based on the type of attribute (Full for keys, Unrestricted for others).
NoneNo aggregation for the cube should include this attribute.
UnrestrictedNo restrictions are placed on the Aggregation Design Wizard.
FullEvery aggregation for the cube must include this attribute.
Default value is Default.
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. This property can have the following values:
Value
Description
FullyOptimizedThe instance builds indexes for the hierarchy to improve query performance. This is the default value.
NotOptimizedThe instance does not build additional indexes.
Default value is FullyOptimized.
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
Concepts
Defining Cube Dimension Properties
Defining Cube Hierarchy Properties
Aggregations and Aggregation Designs (SSAS)