Virtual Cube: Common Dimension

[JUnit]

Hi everyone,

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

JUnit

[JUnit]

Okay my example was not the best I guess ^^ So I will simplify my question a bit:

Is it possible to manually define the dimensions that link the two underlying cubes of a virtual cube?

[JUnit]

No ideas?

OK... I guess the "join" is realized via a shared dimension and there is no way to tell mondrian that it should use two private dimensions...

[wafastat]

Hi JUnit,
I have the same problem, i want to create a cube using 2 facts i worked with the virtual cube and defined the dimensions from the 2 facts but the problem is with the measures when i add the virtual measures and then run the mdx query i have this error : Mondrian could not be done for my schema !! and when i delete the measure the connection is done but i have no measure to run the query!!
Do you have an idea about that?

[wafastat]

In fact, it was just a matter of name : i.e in first time i named the measures like they were called in the seperated cubes but their have to be in this form [Measures].[nom de la mesure].
For more details in how to build virtual cubes follow this http://forums.pentaho.org/showthread.php?t=63081