HierarchyStructureType Enumeration
Collapse the table of content
Expand the table of content

HierarchyStructureType Enumeration


Applies To: SQL Server (starting with 2016)

An enumeration of the different hierarchy structure types allowed by the engine.

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

public enum HierarchyStructureType

Member nameDescription

A hierarchy identified by the engine as Natural. An example of a natural hierarchy is a structure consisting of dates, where a given calendar year is the natural parent of a set of quarters, and a given quarter is the logical parent of a set of months, and a given month is the natural parent of a set of days.


The hierarchy is of an unknown kind.


Usually a user defined hierarchy that the engine was not able to classify as a natural hierarchy.

Return to top
© 2015 Microsoft