Work around ambiguous path

[Graciex123]

Looking for help with ambiguous path. I have a project report table with core information about the project. I also have two tables where i have transactions for the projects (expenses & actual hours)

Currently I have relationship to a dim_date table as I need the dates of the transactions but also the year of the project to be performed.

There is also a connection to a site core data from the the project report table to be able to slice for country, region & site.

But to connect the transaction to each project I wanted to connect the project name from the transactions to the project name in the project report.

It won´t let me keep them active.

Any tips to improve or fix this?

See below picture.

[lbendlin]

You probably don't need either of these connections since you have already wired your fact tables into the date dimension table.