Role Playing Dimension

Ch.02: DWH | DWH Components | Data Modeling | Dimension Types

Lesson Notes

Role-playing Dimension Lesson Notes

Video

Role-Playing Dimension

Role-Playing Dimensions (Re-usable Dimension): A single physical dimension helps to reference multiple times in a fact table as each reference linking to a logically distinct role for the dimension.

Role-Playing Dimension Example

Role Playing Example

Conformed vs Role-Playing Dimension

  • Conformed is the same dimension used in different facts and has the same meaning ex: CustomerID.

  • Role-Playing is the same dimension which used multiple times within the same fact but with different meanings ex: Date.

Further Reading

  • Chapter 6.3.9 Role-playing dimensions page 285 from Dimensional Modeling: In a Business Intelligence Environment. The book is free, and you can download it from this link.

Previous Chapters

Overview | Ch.01: Intro