Attached is a sample qvw file with sample data and the circular loop.
What could be done in data model to avoid it ?
Could someone guide me in the right direction ?
Many thanks in advance.
Remove the table:
/*[Sales network-Item category]:
LOAD * INLINE [
Sales network, Item category,
as it is a linking table but all the table are already linked without it.
did you merge four tables into one?
I don't think it's could works for my requirements.
specially because the end user has an input date (MM/DD/YYY) to submit and should be able to see what happened at that date, to what sales network and item category the sales agent belonged to.
You say 'the end user has an input date (MM/DD/YYY) to submit and should be able to see what happened at that date'
I somehow suspect you'll need to create a SCD [Slowly Changing Dimension] table quite likely by exploiting IntervalMatch().
Are there any other requirements not mentioned in your original question ?
Thanks to all for your quickly reply.
Finally I decided to rename the field "Item category" of table "Sales network-Item category" to "Network category".
In this way I can show in UI both dimensions in order to check if the sales agent sold items that he should not.