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 :)

[Arpitagrawal9]

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.

[sdf]

Hi,

I know this is an old post but with regards to creating shortcuts/alias to avoid loop joins, I would like to know how to treat this kind of relationship in the business layer? Should I select all tables including the shortcut? Coz I'm thinking this might confuse the end users when they are creating reports.

Also is it ok to do the shortcut joins in the business layer instead of the database layer?


Please advise for best practices.

Thanks!