Intervalmatch and Link Table?

[#1]

Hello everyone!

I'm having difficulties with my data model and maybe someone can help!  I have two fact tables:

     1. Shipment lines:  Has a date field, and transaction quantities

     2. Pay Period Ending:  Has an Ending Date, and a number of productive hours assigned.

I want to find out what the ratio of    Sum([SHIPPED-QTY]) / Productive hours within a week.

To establish which PPE period a transaction is assigned to, I used an Intervalmatch.  However I am now caught in a circular loop I do not know how to get rid of.  After some researching, I think it has something to do with creating a Linktable?

Does anyone have any ideas?  I've attached a .qvd

Thank you all in advance!

[#2]

To further clarify:

Shipdate is used in WHSHIPLINE to find out which PPE_Period each transaction is in.

There are multiple COMPANYs that have different XXX_Hours values as well as transaction lines...

[#3 · Accepted solution]

I may be onto something... using a Join to "flatten" out the data model, and remove the intervalmatch table...