Dim Date table to another table How to create relationship? b/w two tables?

[gkv]

Hi Team,

i have a 2 tables called product and dim_date.

now i have to create relationship b/w the two tables using dates column.

how can i create?

i tried this way but its showing error.

explore: product{

join:dim_date{

type:left_outer

relationship:one_to many 

sql: ${product.date}=${dim_date.date}

}

}

its showing error. if i change type and relationship also its showing error.

please help me on this and what are the possible ways to implement global dates.