AttributeHierarchyOptimizedState Element (ASSL)

Determines the level of optimization applied to the attribute hierarchy.

Syntax

<DimensionAttribute> <!-- or CubeAttribute -->
   ...
   <AttributeHierarchyOptimizedState>...
   </AttributeHierarchyOptimizedState>
   ...
</DimensionAttribute>

Element Characteristics

Characteristic	Description
Data type and length	String (enumeration)
Default value	FullyOptimized
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent element	CubeAttribute, DimensionAttribute
Child elements	None

Remarks

The value of this element is limited to one of the strings in the following table.

Value	Description
FullyOptimized	The instance builds indexes for the attribute hierarchy to improve query performance.
NotOptimized	No additional indexes are built by the instance.

The enumeration corresponding to the allowed values for AttributeHierarchyOptimizedState in the Analysis Management Objects (AMO) object model is OptimizationType. The elements that correspond to the parents of AttributeHierarchyOptimizedState in the AMO object model are CubeAttribute and DimensionAttribute.

See Also

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance