Description
When building the cube, step 2 data model, as in DW star schema, it’s normal we have some role play dimensions, like org unit, date or employee, one dimension could be used several times to join with fact table when doing the data modeling, and when it comes to step 3 Dimentions, when adding dimensions, the dimension tables displayed multiple times. Normally it shall be good to use some alias in this step, otherwise I don’t know which dimension I’m actually using.