Author Topic: HOW TO AVOID LOOP JOINS IN FW MGR  (Read 8003 times)

Offline kittu7007

  • Associate
  • **
  • Join Date: Aug 2009
  • Posts: 4
  • Forum Citizenship: +0/-0
HOW TO AVOID LOOP JOINS IN FW MGR
« on: 26 Oct 2009 09:15:39 pm »
Hi all,
Can any body explain me how to avoid loop joins in Report Net FW MGR

Offline NaviGator

  • Community Leader
  • *****
  • Join Date: Sep 2008
  • Posts: 137
  • Forum Citizenship: +2/-0
Re: HOW TO AVOID LOOP JOINS IN FW MGR
« Reply #1 on: 27 Oct 2009 02:31:01 am »
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 ..
Never Stop Learning ..

Offline kittu7007

  • Associate
  • **
  • Join Date: Aug 2009
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: HOW TO AVOID LOOP JOINS IN FW MGR
« Reply #2 on: 09 Nov 2009 10:23:29 pm »
THANKYOU NAVIGATOR :)

Offline Arpit Agrawal

  • Arpit Agrawal
  • Community Leader
  • *****
  • Join Date: Jun 2011
  • Posts: 92
  • Forum Citizenship: +5/-0
  • Have no fear of perfection--you'll never reach it.
    • Infocepts
Re: HOW TO AVOID LOOP JOINS IN FW MGR
« Reply #3 on: 14 Jun 2011 02:10:00 am »
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.

Thanks and Best regards,
------------------------------------------------------------
Arpit Agrawal | InfoCepts | www.infocepts.com
------------------------------------------------------------

Offline sdf

  • Statesman
  • ******
  • Join Date: Feb 2014
  • Posts: 338
  • Forum Citizenship: +3/-0
Re: HOW TO AVOID LOOP JOINS IN FW MGR
« Reply #4 on: 01 Jan 2018 10:24:21 pm »
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!

 


       
Twittear