Multiple choice technology packaged enterprise solutions

Hierarchies have

  1. One to One relationship

  2. Many to One Relatioship

  3. Many to Many Relationship

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Essbase hierarchies, multiple child members roll up into a single parent member, creating a many-to-one relationship from bottom to top. For example, multiple product-level members aggregate into one category member, and multiple categories further aggregate into a total product member.

AI explanation

In a dimensional hierarchy (like in Essbase or OLAP modeling), each child member rolls up to exactly one parent member, while a parent can have many children — this is the defining many-to-one relationship of a hierarchy. This is what allows aggregation to work cleanly: values roll up unambiguously from children to a single parent at each level.

Keep practicing — related questions