Help to Solve on to many relationship involving measure

[system]

Welcome to B:bob:B!

The problem that you are experiencing is called a fan trap. It’s described here:

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…

You can find the resolution of the fan trap there too.

---

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