A role playing dimension is a dimension that can be aliased multiple times to fulfill analysis in different context. The Time dimension is a role playing dimension. Suppose the fact table has an order date, shipment date, and delivery date keys .We can create three aliases of the Time dimension (three roles) in the semantic layer of the reporting/OLAP tool and name them as Order time dimension, Shipment time dimension and delivery time dimension. The key is to remember that we do not create multiple physical copies of the time dimension table but only create aliases in the logical layer.
In other word we can say that, the same dimension which can be used for
multiple purposes.
I am looking for some good blog sites for studying. I was searching over search engines and found your blog site on readymade project shop near me
ReplyDelete