• 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