Role Playing Dimension implementation in Data Warehouse is required on Date dimension.
Now, What should be the best approach ?
Approach 1: Create multiple views on the Date Dimension. Then import all the views in RPD. Then provide joins among the views and the fact.
Approach 2: Create multiple Aliases on Date Dimension in RPD physical layer. Then provide joins among the Aliases and the fact.
Kindly consider the performance also.