I’ve got an issue with Shortcut joins in IDT.
If I put my join in as a shortcut and select tables that should use it then it gets ignored and goes round the long way (which is wrong).
If I change to a normal join and select the same objects it uses the normal join, and selects the correct path.
I’ve tried adding in the SHORTCUT_BEHAVIOR parameter and if I put in Global or Successive it bolds it as if it’s an error.
Any thoughts?
Damocles 
(BOB member since 2006-10-05)
The fact that works at all as a normal join tells me something is screwy with the model – you should get an error since it’s a loop. Do you have all cardinalities defined? And are you using contexts? And if so, are all the joins in one context?
joepeters 
(BOB member since 2002-08-29)
I would like to see a picture.
Shortcut joins are applied after contexts are evaluated. They are used only if they can legitimately replace a longer join path with a shorter path. If you’re trying to use a shortcut as an alternative to a context, it’s not going to work as expected / desired.
Dave Rathbun (BOB member since 2002-06-06)