InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is Fan trap? How do you resolve this? |
|
Answer» In a Universe, when you have 3 tables in structure and first table is joined with one to many relationship with second table which is connected with one to many relationship with third table and when you drag a measure from 2nd table and dimension from 3rd table, value of measure is inflated, this condition is called Fan trap. You can resolve this by creating an alias of the 2nd table and defining contexts so that normal table is joined only with the first table, while the alias is joined with both the 1st and the 3rd table. We would take 2nd table’s measure only from the normal table and other dimensions of the 2nd table from the alias table. |
|