Handling InActive Relationships - Creating Charts with Hierarchy

[Anonymous]

Please find my below table relationship. 

PlantPerformance, DateTable and StageTable are the main table available linked together using a date field in it.

DISTINCTAUFNR and DISTINCEMODEL are just distinct value bridge tables created by me to avoid many to many relationships and create one to many relationships between PlantPerformance and StageTable. PlantPerformance and StageTable are linked using "Production Order ID" and "Model ID"

I am trying to bring a report like below. The above date filters comes from the table "DateTable". The chart contains the X axis "ValueStream" field taken from "PlantPerformance" and "StageQuantity" filed taken from "StageTable". 

I am not getting the StageQuanity based on ValueStream due to the inactive relationship between the PlantPerfomance and StageTable using Production Order ID and Model ID.

How to handle this one ? Could you please help me in detail so that i can understand easily ?

[amitchandak · Accepted solution]

@Anonymous , There are too many bi-directional joins. Make them a single directional, unless most need.

These are creating multiple paths, because of that some join are becoming inactive.