BusinessObjects Board

Inflated figures

Hi,

I’ve got a join between two tables. One table has duplicated ID’s and when I join to that table (1,1) the measures are increased by how many times the ID is in the table. How do I resolve this?


sel (BOB member since 2008-04-23)

it is called a fan trap.

Your options:

  1. Do not do the join :wink: or
  2. Remove the duplicate IDs physically from the one table or
  3. Create a view or derived table stripping out the duplicate IDs and then join it to your fact table. Or crate a bridge table.

Andreas :de: (BOB member since 2002-06-20)

Hi!

Thanks!I know it’s a fan trap but what’s the best way to resolve this many to many relationship. I can’t remove the duplicates and I actually need this table to stay as it is becuase others tables join it the use this field.


sel (BOB member since 2008-04-23)

Hi,

There is a Designer’s FAQ for a fan trap:

In case you would need it, there is also a Designer’s FAQ for a chasp trap:

Also search the forum for many many many discussions that talk about these two topics.


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