CubeHierarchy Data Type (ASSL)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Defines a primitive data type that represents information about a Hierarchy element in a Cube element.


<CubeHierarchy>   <HierarchyID>...</HierarchyID>   <Name>...</Name>   <OptimizedState>...</OptimizedState>   <Visible>...</Visible>   <Enabled>...</Enabled>   <Annotations>...</Annotations></CubeHierarchy>  

Data Type Characteristics

Characteristic Description
Base data types None
Derived data types None

Data Type Relationships

Relationship Element
Parent elements None
Child elements Annotations, Enabled, HierarchyID, Name, OptimizedState, Visible
Derived elements Hierarchy (Hierarchies collection of CubeDimension)


This data type has no restrictions and can be used under any deployment mode: 0-Multidimensional and Data Mining, 1-SharePoint, and 2-Tabular.

In SQL Server 2016 Analysis Services and later, the Enabled property cannot be set to False for CubeHierarchy.

The corresponding element in the Analysis Management Objects (AMO) object model is CubeHierarchy.

See Also

Discover Method (XMLA)
Analysis Services Scripting Language XML Data Types (ASSL)