Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Role Playing Dimension

Role Playing dimension refers to a dimension can play different roles in a fact table depending on the context. For example, the Date dimension can be used for the ordered date, scheduled shipping date, shipment date, and invoice date in an order line fact.

In the data warehouse, you will have a single dimension table for the dates. You will have multiple warehouse foreign key from the fact table to teh same dimension.

In Oracle BI Server, the role playing dimension can be created as multiple alias in the physical layer of the repository file (RPD). You can create the foreign key relationship from the fact table to the different alias of the dimension table.