I need to create a joined cube where the relation must be on two dimensions. When I have tested this, it seems it created the relation as an "OR" relation, not an "AND" relation. I cannot see how I can change this.
Please advise if there is a way?
There is no option to set AND or OR while joining two cubes via linked cube. It is always AND between various joining conditions. Can you check once again at your end? If required, we can have a shared session through anydesk to look into the same.