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