AttributeHierarchyOptimizedState Element (ASSL)


Applies To: SQL Server 2016 Preview

Determines the level of optimization applied to the attribute hierarchy.

<DimensionAttribute> <!-- or CubeAttribute -->  

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

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

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