﻿SQLServerCentral.com / Analysis Services / Data Warehousing /
What is role playing dimension / Latest PostsInstantForum.NET v2
.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/n
otifications@sqlservercentral.comMon, 05 Oct 2015 14:06:12
GMT20RE: What is role playing dimensionhttp://www.sqlservercentr
al.com/Forums/Topic1578145-17-1.aspxSuppose you have a fact
table in which you store orders from an e-commerce website.There
are various dates linked to a transaction:* order date = the
date the customer ordered something on the website* due date =
the date the package should be delivered at the customer* ship
date = the date the package left your warehouseThis means there
are 3 links to the date dimension of the data warehouse.An
example of a fact line may be:CustomerID OrderDate DueDate
ShipDate Quantity Amount14587 20140606 20140610 20140608 1
25.87When you load this data into SSAS, you have two options.1.
You create 3 seperate dimensions (Order Date, Due Date and Ship
Date), each based on the same