Dimensional Modeling, Role Playing Dimensions!!!
Technical definition of Role Playing Dimensions, my own and not from any purists, "If a dimension is joined to a particular fact table in more than one ways, by nature of design it is a Role Playing dimension". Or defining in an OOPs way, if a relationship of dimension with fact table or a measure group is polymorphic in nature then we can call that dimension a "Role Playing Dimension".
Read more...