Using Ragged and Unbalanced Hierarchies

[rclapp]

Problem
We are exploring cube for a POC with in my team and we had a few questions on hierarchies. The documentation mentions that level definitions for hierarchies are needed, how does this with with ragged hierarchies. Specifically ones that have a high cardinality of levels. We typically store these in adjacency lists (Parent Node, Child Node). As a part of these adjacency lists we also store a weight, that describes whether the children within the parent are additive (weight of 1) or subtractive (weight of -1). Wondering if anyone has guidance or experience they can share.