The Modeling Room: (M2) Describe the people & things - (A7) Discover dimensions
Series: The Modeling Room, module 2, article 7 of 26. Follow the bike-shop conversation that separates the recorded repair from the descriptions used to report on it. Build a dimension candidate card, test it with another repair, then run the same 4 steps on your own domain.
Who should read it?
Students learning modelstorming, analysts, report builders, data modelers working with business experts
Prerequisite
read an event table and say what one row means, as in part 6.
Learning objective
Distinguish a detail of an occurrence from a description of its participants, and record a dimension candidate with a clear row meaning
Artifact
Dimension candidate cards with row meaning, example members, descriptions, reporting use, and open checks
Why this matters
Alex Morgan wants to compare electric-bike work with other work and suggests copying the bike's model name and propulsion into every activity row. Anna Bennett asks who will keep the copies consistent.
Copied descriptions drift: one corrected copy leaves another with the old label, and reports sort the same bike into conflicting groups.
What you'll learn
- How to tell a detail of the recorded work from a description of its participants.
- How to build a dimension candidate card with a row meaning, example members, and named open checks.
Your output: one candidate card you can explain and test.
New terms: dimension, attribute, dimension member