_Hierarchies

The _Hierarchies table stores the name, dimension, properties, and data source for the hierarchies. There are two different kinds of hierarchies, parent-child and attribute driven.

If you chose to load by the _Hierarchies table, you must load the elements in the hierarchy.

This table describes _Hierarchies:

Column Type Description
HierarchyName String(50) Name of hierarchy.
HierarchyDescription String(150) Description of hierarchy.
DimensionName String(50) Name of dimension hierarchy belongs to.
SourceId Integer Data source of hierarchy. This links to the SourceId key of the _Sources table which describes the details of the source.
HierarchyType Integer Enumerator for the hierarchy type of the hierarchy.
  • 0 = Parent/Child hierarchy from a combined table containing members, attributes, and implied relationships.
  • 1 = Parent/Child hierarchy with separate member and relationship tables.
  • 2 = Attribute Driven hierarchy.
Param1 Text First parameter.

For HierarchyType = 0, this is the name of the combined table.

For HierarchyType = 1, this is the relational table source of the hierarchy data, the members' table. This can be a sub-query.

For HierarchyType = 2, this is the ID of the hierarchy parameter list.

Param2 Text Second parameter.

For HierarchyType = 0, this is the top level element name.

For HierarchyType = 1, this is the relational table source of the hierarchy relations data. This might be the same table as the members' table found in Param1. NULL if there are no relations for the relational source. This can be a sub-query.

DefaultElement String(71) If an element of a hierarchy is not specified, take it to be this one. NULL if there is no default element. If specified default element is not present in hierarchy, no default element property is created and a warning is issued in the log file.
ExtendedProps Text The extended properties of the hierarchy expressed as an XML document string. NULL means the hierarchy has no extended properties.
Comment Text User defined comment.

General information

Param1 for HierarchyType 2 is the numeric ID of the list of parameters describing the attribute driven hierarchies found in the _Parameters table.