2 Replies Latest reply: Apr 15, 2014 3:20 PM by Stephen Daspit RSS

    IntervalMatch with additional key leads to "false" matches; circular loop otherwise

      Hello. I am struggling with IntervalMatch creating either a circular loop or "false" matches based on which treatment I choose.


      For starters, I've modeled heavily from this: IntervalMatch and Slowly Changing Dimensions. My scenario is closest to the "Two interval tables mapped against a common dimension ID and a common time line" example in the linked PDF.

      In brief, discrete events (on different inventory items) can share a start and end time, so the bridge table is incorrectly linking different events. When I try to force an InventoryID into both tables, I get circular reference errors.

      Please see the attached .QVW. Of note, it is currently set up with the bridge table. You can see how an EventId (which corresponds to only a single InventoryId) is being linked to multiple InventoryIds because their start and end times are the same.

      I feel like I'm close, but I've been circling the drain on this for a few days.