Join a Dimension table to two Fact tables without causing a loop

[darren_dixon]

Hello,

Problem
Please could you advise the best way to link a Dimension table to two Fact tables without causing a loop.

Currently, the DimRentSubAccount is linked to the FactBalance table. I want to join this with the FactTransaction table.

Desired Outcome

I want to be able to select a Sub Account from DimRentSubAccount and see the results in FactBalance and FactTransaction.

Thanks in advance for your assistance.

Darren

[marcus_sommer]

In this case you should put this field into the link-table.

- Marcus