HOW TO AVOID LOOP JOINS IN FW MGR

[kittu7007]

Hi all,
Can any body explain me how to avoid loop joins in Report Net FW MGR

[NaviGator]

Hello Kittue7007,

There are many ways to avoid loop joins.

First of all you have to make sure that you have the right joins and that you have defined the joins correctly. Make sure that the relations between your tables are defined correctly ( one-to-one or one-to-many relations ).

If you have to join 2 tables more than once or if you have to join the table to itself ( Parent-Child relationship ), the best way to model this is to create another copy of the table and use it for the join This will help you to avoid looping.

In the FM manual there is a complete chapter for modeling techniques that you can use to avoid loops or data traps.

Thanks ..

[kittu7007]

THANKYOU NAVIGATOR

[Arpit Agrawal]

In this case,if u are following the arrows concept it will leads us back to where we started. Every query subject in the loop depends on every other, directly or indirectly, including itself. In this case, the arrows don’t tell us where to break the diagram, so we have to use our knowledge of the data. Which table has the most rows? That one must be the fact table.