How could I make a join between fact table and dimension

[grodeg]

Hello,

For different reasons I'd like to keep may DWH out of foreign keys between fact table and dimension

Once I connect with Mondrian, it tives me an error becaus ethere is no foreign keys between my hierarchy and my fact table.

I read on Pentaho documentation that join is not used between fact and dimension table.

The question is : is there a solution to make explicit joins in xml file between fact table and dimension table or is the only way to do it is to declare foreign keys in fact table matching id of dimension table

Thank you

Jérôme

[bhagan]

Dimensions are joined to the fact table through foreign key references. This is explicitly expressed in the mondrian schema file. Please review the mondrian schema documentation here:

http://mondrian.pentaho.com/documentation/schema.php