Traps

[system]

Can anybody tell me why we say that chasm traps and fan traps return too many rows. Please explain with an example the whole procedure?

---

asifmunshi (BOB member since 2006-07-15)

[system]

Please search under Designer FAQ for a detailed explaination.

120×120 10.4 KB

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: Dave’s Adventures in Business Intelligence » 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 O…

---

Kashif Saeed (BOB member since 2004-06-02)