Fan traps occur when there is a one–to–many join to a table that fans out into another one–to–many join to another table.
![](/service/media/topic/b24e7307-1632-44ec-bb86-03c82b4be1a0/BOID10_19_en-US_media/BOID10_19_en-US_images/One-to-Many fanningtoAnotherone-to-manyjoinflow_Image.png)
With such a table structure and joins, you get incorrect results from the fan trap when the query includes a measure object on the middle table (B) of the table path and an object (of any kind) from the subsequent table or tables (C).
When a query is run using objects Y and Z, the inferred SQL includes tables B and C, which have a one-to-many relationship. This results in a value for the Y object being multiplied by the number of values of the Z object related to that Y object value. Like the chasm trap, the effect is similar to a Cartesian product.
![](/service/media/topic/b24e7307-1632-44ec-bb86-03c82b4be1a0/BOID10_19_en-US_media/BOID10_19_en-US_images/FanTrapIssue.png)
You cannot automatically detect fan traps. You must examine the direction of the cardinalities displayed in the table schema.