if I create a Virtual Cube Mondrian automatically knows which dimensions the "joined" cubes have in common. But let's imagine the following scenario:
I would like to integrate data from 2 cubes, each of them has a dimension that contains an employee-id. These dimensions reference to different tables because the data comes from different source systems. So the dimensions have different names but contain excactly the same content.
Is there any chance of defining the common dimension manually so that Mondrian uses two dimensions with different names to join the virtual cube?
Thanks in advance