Forum Discussion
Data Modeling - How do I connect two Facts to two dimensions
Hi Anonymous ,
What you want is a model like this?If you want to build this kind of table model, there must be a 1: * or 1: 1 relationship between the tables.
Why don't you build relationships directly between Tables "FactSupply" and "FactDemand"? I think this can also achieve your visual effects.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
What you want is a model like this?
If you want to build this kind of table model, there must be a 1: * or 1: 1 relationship between the tables.
Why don't you build relationships directly between Tables "FactSupply" and "FactDemand"? I think this can also achieve your visual effects.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for sharing the diagram and (1: * or 1: 1 relationship) tip!
It made me think it is possible what I was looking for.
I actually had developed this habit of selecting the Cross Filter Direction to be Both.
Because of this I couldn't make all these 4 relationships active at once. Once I switched it to Single, it started working.