Hi,
I am unable to join 3 tables as described in http://mondrian.pentaho.com/document...p#Star_schemas . How to join three tables to be a dimention.
Lets say,

factTable
col1

Table 1
col1 (pk)

table 2
col1(mul)
col2 (mul)

table3
col2(mul)
col3 (pk)

Version SchemaWorkbench 3.5
jdbc=com.mysql.