The Modeling Room: (M2) Describe the people & things - (A12) Reuse a date dimension

Series: The Modeling Room, module 2, article 12 of 26. Name every business date role, share one calendar definition, and record the time rules that decide which days a report selects. Two report tests then show what a wrong role would move out of the requested day.

The Modeling Room: (M2) Describe the people & things - (A12) Reuse a date dimension
Reuse one calendar through explicit business date roles without changing their meanings or interval rules.

Who should read it?

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

Prerequisite

You keep one customer across a dated change and select the version valid at the business time, as in article 11.

Learning objective

Reuse one calendar through explicit business date roles without changing their meanings or interval rules.

Artifact

A date-role map, shared DATE card, time-rule card, and expected report selections

Why this matters

Oliver Reed performed JOB-2041's brake service on September 14. The customer collected the bike on September 15. Ask for "the September report" and both dates look right. Pick the wrong one and real work moves out of the requested day while every total stays correct. The failure is a missing role name.

What you'll learn

  • How to name each business date role with its question, then share one calendar definition without merging meanings.
  • How to write the time rules and report tests that show which days each role selects.

Your output: a date-role map, shared DATE card, time-rule card, and expected report selections.

New terms: date role and role-playing dimension

This post is for paying subscribers only

Already have an account? Sign in.