AttributeHierarchyOptimizedState Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Determines the level of optimization applied to the attribute hierarchy.

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

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueFullyOptimized
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementCubeAttribute, DimensionAttribute
Child elementsNone

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

ValueDescription
FullyOptimizedThe instance builds indexes for the attribute hierarchy to improve query performance.
NotOptimizedNo 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.

Properties (ASSL)

Community Additions

ADD
Show: