Summing a measure

[system]

I’m new to web intelligence and am having an issue with summing a measure. I am working through invoices that have a term and reporting year associated with it. When placing the term and invoice total on the report the sum of the totals appear correct by term but if I drag the reporting year and invoice totals onto the report it gives the same amount for all the reporting years. This amount ends up being a sum off all of the invoices. Any help will be appreciated.

---

zham (BOB member since 2015-09-01)

[system]

Yours is a classic fan trap situation. Please try to find the tables in your universe which are involved with this measure. You may need to Alias one of the table and create a context in universe to resolve this.

---

americanmc (BOB member since 2009-12-31)

[system]

Agreed, sharing a topic on fan trap, just in case if you have no idea about 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…

---

Prashant Purohit (BOB member since 2009-02-18)

[system]

Thanks. I finally saw that it was left out of a context this afternoon.

---

zham (BOB member since 2015-09-01)

[system]

Ok but generally if you miss out some join in context, error is thrown but anyways you got it working, all the best!!!

---

Prashant Purohit (BOB member since 2009-02-18)

[MarkP]

@Prashant Purohit

Ok but generally if you miss out some join in context, error is thrown but anyways you got it working, all the best!!!

Not necessarily. The join could belong to 2 contexts when it should belong to 3