Dear All,

I'm a user of Pentaho 1.6.

Anybody knows how to create Cube (CubeDef.mondrian.xml) from a fact table which has more than one the same dimension?

For example, I have fact table of traffic_analysis which contain 2 the same dimension which is location. One location is source_location and the second is destination_location, both refer to the same dimension table: location.

I thought that I could use DimensionUsage but I was wrong. It can't be used to the same Cube.

Would you give any information or references about how to solve this problem?

Many thanks.