resolve loops

[former_member214617]

i have table t1 which is main table and connected to table T2 & t3 (one-to-many)

where T2 is connected to T3 (one-to-many)

T3 is connected to T4 (one-to-many)

T2 is connected to T5 (one-to-many)

T5 is connected to T4 (one-to-many)

i have tried creating context but while creating them it is detected 1 loop.

help me to resolve this

if you need more info please let me know

thanks & regards

[Former Member · Accepted solution]

What is your reporting requirement? Can you give more details?

Also, check the use of T4 table.. if it is used for different purpose then create alias of T4 for resolving the loops.

Regards,

Rohit

[MariannevL]

I agree with Rohit, you need to consider the functional use of the tables and joins.

An example,

T1->T2>T3 implies T1->T3, so it sounds like a shortcut join.

However, if going via the join path T2,T3 would yield different rows then when you go directly, it is not...

Same with the T2,T3,T4 route vs. the T2,T5,T4 route.

Real life names of the table would help.

And the functional roles of the joins even more.

So please provide more info if you want a good answer...

Thanks,

Marianne