Fantrap means one-to-many joins of the tables it is 
detected by visval analysis. By using fantrap problem is  
many rows than expected. Through aliases,context and check 
mutiple sql statements for each measures option we can 
solve this problem.


chasm trap means two or more many to one joins converge on 
to a single lookup table

Chasam Trap:

chasm trap means many-to-one and one-to-many join relation 
converge on to a single lookup table, because of this we 
get incorrect results i.e., cartision product, We will 
resolved by using some times alias, some times context, 
some times shortcut join and check mutiple context for each 
measures option.

Fan Trap:

Fantrap means one-to-many and one-to-many join relation of 
the tables it is detected by visval analysis, because of 
this we get incorrect results i.e., cartision product, 
We will resolved by using some times alias, some times 
shortcut join and check mutiple sql statements for each 
measures option.