Hierarchy

Overview

A Hierarchy is an AnalyticsCreator analytical object that organizes table columns into ordered levels.

It provides a reusable navigation path for OLAP and data mart analysis.

Use hierarchies to define how users move from higher-level values to more detailed values in analytical output.

Each hierarchy belongs to one analytical table and contains an ordered list of hierarchy levels.

Attributes define the configuration, behavior, and relationships of the hierarchy entity.

Attribute	Applies to	Description
Schema	Hierarchy	Schema that contains the analytical table.
Table	Hierarchy	Analytical table that provides the hierarchy columns.
Name	Hierarchy	Required hierarchy name.
Description	Hierarchy	Documents the purpose of the hierarchy.
Column	Hierarchy level	Table column used for the level.
Sequence number	Hierarchy level	Controls the level order.
Level name	Hierarchy level	Business-facing name of the level.
Level description	Hierarchy level	Documents the meaning of the level.

Use case	Description
Create drill paths	Define ordered levels such as Year, Month, and Day.
Standardize analytical navigation	Reuse the same level order across analytical output.
Document semantic structure	Assign business names and descriptions to hierarchy levels.

Related entity	Relationship
Table	A hierarchy belongs to one analytical table.
Column	A hierarchy contains ordered table columns.
Schema	The owning table determines the hierarchy schema context.
Partition	Hierarchies and partitions can both be defined for analytical tables.

Configure or review this entity from the matching AnalyticsCreator user-interface area.