Skip to content

Latest commit

 

History

History
73 lines (60 loc) · 2.52 KB

File metadata and controls

73 lines (60 loc) · 2.52 KB
title AttributeHierarchyOptimizedState Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
AttributeHierarchyOptimizedState Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
AttributeHierarchyOptimizedState
helpviewer_keywords
AttributeHierarchyOptimizedState element
ms.assetid d87148c8-2011-45ae-94c3-851f48babc5f
caps.latest.revision 37
author Minewiskan
ms.author owend
manager erikre

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 xref:Microsoft.AnalysisServices.OptimizationType. The elements that correspond to the parents of AttributeHierarchyOptimizedState in the AMO object model are xref:Microsoft.AnalysisServices.CubeAttribute and xref:Microsoft.AnalysisServices.DimensionAttribute.

See Also

Properties (ASSL)