The Modeling Room: (M2) Describe the people & things - (A9) Model hierarchies

Series: The Modeling Room, module 2, part 9 of 26. Build a part-to-group hierarchy with the bike-shop team. Trace three fittings into grouped results, expose a second-parent error, and keep missing categories visible without losing recorded work or money.

The Modeling Room: (M2) Describe the people & things - (A9) Model hierarchies
Agree a simple grouping hierarchy and test whether it preserves the selected occurrence count and charge.

Who should read it?

Students learning modelstorming, analysts, report builders, data modelers working with business experts

Prerequisite

Distinguish a member's identity from its labels and stored row keys, as in article 8.

Learning objective

Agree a simple grouping hierarchy and test whether it preserves the selected occurrence count and charge.

Artifact

A two-level hierarchy card with member-to-parent examples, relationship and totals tests, and named open checks.

What you'll learn

  • How to agree a simple detail-to-parent grouping path and test both directions.
  • How to trace every selected occurrence into a grouped result and challenge the path.

Your output: one hierarchy card with mapping, checks, a rejected alternative, and named open checks.

New terms: hierarchy and rollup.

This post is for paying subscribers only

Already have an account? Sign in.