Forum Discussion
Visualization between 3 tables
Hi there! I have One table with ID(unique), and two another tables with duplicated IDs, so for "General" tables I create (1:*) relationship to both direction, as you can see in screenshot. So ...
You will want to seriously rethink your data model. Generally when you have a 1:* relationship you want the search filter to flow only from the 1 to the *. The 1 represents the dimension table and the * represents the facts table. Ideally you would want to end up with a star schema. Try to avoid bidirectional searches (unless you have really good reaon) and *:* relationships.