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.
Never Miss an Articles from us.