Hi all,
newbie for universe creation.
I have the following relationship in universe , need ur suggestions on this
Market Dim (1)----< Brand Dim(N)----<Product Dim (N)----<Sales Fact(N)
Is above structure with cardinality & relationship cause a trap?
Thanks in advance
Newbie2011 (BOB member since 2007-10-05)
Is there any measures available on any of the tables?
chetan86 
(BOB member since 2011-01-18)
thanks fo response, Measure available in Sales Fact(N)
Newbie2011 (BOB member since 2007-10-05)
What do you think the answer is, and why? 
Dave Rathbun 
(BOB member since 2002-06-06)
might be incorrect…looks as Fan trap and cardinialities are 1:M:M:M…also M:M need to be handled…thinking for approach…
Newbie2011 (BOB member since 2007-10-05)
Fan traps are defined by measures. Since you only have measures at the end of your join chain, you’re fine. There are no fan traps.
Dave Rathbun (BOB member since 2002-06-06)
Thanks a lot Dave… clear now
Newbie2011 (BOB member since 2007-10-05)
I have investigated lot in Forum for my issue. but i am not sure whether my scenario is a trap or not. can some one please confirm me.
I have 3 tables A—>B---->C(1:n to 1:n) as per the posts i read, i feel this is an Fan Trap.
If i pull objects from A and B then it works fine. If i include measure object from C then it is giving me 2 select clauses, but still gives me the correct data. Now, the problem is if i pull the dimension object from C table, then measure result is more then expected. I have only 2 objects from C table(1 measure and 1 dimension). I checked the SQL query, and i found the incorrect result is because of the join between table B and C is hitting in the select1. is there any way to restrict that particular join should not hit in select1 or if it is a trap, can some one please help me to solve this.
Thanks in advance
Ashie (BOB member since 2008-09-17)
Do you have any measures in B and C tables,
give me some more details
eswar519 (BOB member since 2009-05-26)
yes, i have measures in all the three tables. please let me know for any other information you are looking for…
Thanks
Ashie (BOB member since 2008-09-17)
Hi, please start with this post and read some of the replies that follow.
Dave Rathbun (BOB member since 2002-06-06)
Thank you Dave,
yes, its an trap and i solved by using alias and contexts.
Ashie (BOB member since 2008-09-17)