# Define a fan trap. How can be it solved?

devquora

Posted On: Feb 22, 2018

In case, if we have three tables in a universe joined in such a way that the first table has a one to many joins with the second one and that second table has a one to many joins with the third table, this situation is known as fan trap. The value of the measure is inflated if the measure in the 2nd table is dragged along with any dimension of the 3rd table.

The solution of fan trap: To solve the condition of fan trap, create an alias of the middle table or 2ns table in such a way that if a normal table is joined with the first table then an alias which is created is joined with both 1st and 3rd table. We will use the other dimensions of the 2nd table from the alias table and the 2nd table’s measure from the normal table.

#### Related Questions

Never Miss an Articles from us.

## Related Questions

#### What do you mean by Business Object?

Business Objects are designed for the business professionals to help them for retrieving the data..