Hi, I hope all is well.
I'm having a dilemma in my cube setup and i hope you guys can help.
I have 1 cube dimension created from a UNION of 2 Dimension tables leaving me with duplicate keys on 1 column. To get around this, in my DSV I connect this dimension to the FACT table with 2 Relationships. Seen below:
Somehow this relationship is not being followed when I view the cube.
have you guys encountered this?