CubeHierarchy Data Type (ASSL)


Applies To: SQL Server 2016 Preview

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>  

Base data typesNone
Derived data typesNone
Parent elementsNone
Child elementsAnnotations, Enabled, HierarchyID, Name, OptimizedState, Visible
Derived elementsHierarchy (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 (SSAS), the Enabled property cannot be set to False for CubeHierarchy.

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

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

Community Additions