Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

HierarchyStructureType Enumeration


Applies To: SQL Server 2016 Preview

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

Community Additions

© 2015 Microsoft