Forum Discussion
join in data model
Hi All, i want to join date dim with multiple facts table with col date table = ddmmyyyhhmm sales facts = ddmmyyyhhmm Target facts=ddmmyyyhhmm joins date table1:M sales facts (both) -...
Anonymous ,
Which type of Cardinality you are using for all three tables?
I checked at my end and got correct result.
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.
Interesting, I am also using same cardinality .
but there are other table as well in the data model , does it affecting this relationship
Hi,
Could you please share your all relationships among tables as a screenshot?
Best Regards,
Giotto Zhi