Those are the role playing dimensions.
You have the order date, the ship date and the due date.
This is realized by joining 3 times to the same date dimension, but each time using a different date column from the fact table.
OrderDateKey -- DateKey
ShipDateKey -- DateKey
DueDateKey -- DateKey
You could use 3 different views on top of the date dimension, but the result is the same.
When you create the cube, you add the date dimension three times as a cube dimension and there you can rename them as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP