Loops

[system]

when to go for aliases ,when to go for contexts ???( For resolving loops)

---

Narne (BOB member since 2005-12-02)

[system]

Please see this post

---

irish_stan (BOB member since 2003-05-13)

[system]

Please review the Designer FAQ entries regarding Fan and Chasm traps.

FAQ: Designer

What is a fan trap, why is it a problem, and how do I resolve it? Dave Rathbun describes it well in his presentation, ZEN and the ART of Universe Design. Which is located here: http://www.dagira.com/conference-presentations/ Here is a quick synopsis of Fan Trap from his presentation: A Fan Trap is a one - many - many relationship. This would happen if you are using a Summary and a Detail table in one query. Fan Traps can cause numbers to multiply. Business Objects resolves this t…

FAQ: Designer

What is a chasm trap, why is it a problem, and how do I resolve it? Business Objects describes it best at this web site: http://tips.businessobjects.com/tips/unvdes/tip/ut001/ut001.htm The Chasm trap occurs when two “many to one” joins converge on a single table. It is a one - many - one relationship. You will get incorrect results when the following circumstances exist: A “many to one to many relationship” exists among three tables in the universe structure. The query includes obje…

---

Dave Rathbun (BOB member since 2002-06-06)