universes

[system]

hi all,
what is traps how to resolve traps issues

---

vjrr (BOB member since 2013-06-17)

[system]

Welcome to B:bob:B!

Check these 2 entries in the Designer’s FAQ:

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…

[Moderator Note: Moved from About BOB to Semantic Layer / Universe Designer]

---

Marek Chladny (BOB member since 2003-11-27)

[system]

thank u

---

vjrr (BOB member since 2013-06-17)