Role Playing Dimension

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

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.