hi i hav three tables
a<b<c having one to many joins.
when i m running a query i m getting the wrong result(i m getting the wrong sum in measures).
i know this is a fan trap.Can anyone tell me how to solve this problem.
DataGenius (BOB member since 2006-06-13)
Hi sharma1523,
You can avoid by creating table Alias.
Creating an alias, creating a context using the alias, then building affected measure objects on the alias.
OR by Using Multiple SQL Statements for Each Measure.
Raja Saripalli 
(BOB member since 2005-12-14)
Fan traps are well documented. Do please take the time to read the FAQ prior to asking a question. 
Dave Rathbun (BOB member since 2002-06-06)