ExplicitHierarchy

Hierarchy with explicitly defined levels organized in a fixed, predetermined structure. This is the most common hierarchy type, mapping to star schema and snowflake schema designs where levels correspond to dimension tables or normalized structures. ExplicitHierarchies provide optimal performance for predictable hierarchical structures and support complex multi-level drill-down operations with explicit level relationships defined through foreign keys.

Extends

• AbstractElement 🔗- Hierarchy 🔗

Attributes

Name	Id	Type	Lower	Upper

References

Name	Type	Lower	Upper	Containment
levels	Level🔗	1	∞	false
Ordered collection of levels that define the hierarchical structure from most aggregated to most detailed. The order determines the drill-down sequence and level relationships. Each level corresponds to a granularity of analysis (e.g., Country -> State -> City) and must be connected through appropriate foreign key relationships in the underlying queries.

Used by

ClassDiagramm