Hierarchies in Datasphere

As of 2026-05-29

2 flavours: parent-child (variable depth, e.g. cost center) and level-based (fixed depth, e.g. fiscal time). Senior pattern: define on analytic model not view, single source consumed everywhere. Time hierarchy = V_DIM_CALENDAR in foundation. Cost center = SCD Type 2 (history preserved). Use server-side hierarchy pre-aggregation for SAC drill perf.