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

darren_dixon — Fri, 22 Jan 2016 12:10:15 GMT

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

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

marcus_sommer — Fri, 22 Jan 2016 15:52:45 GMT

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

- Marcus