Example of how the fantraps and chasm traps works?
Answer Posted / abdul
Chasm trap and Fan Traps are the loops which will occur
while ditecting loops.
Examples of these are:
Chasm Trap:
Orders
Customer <
Sales
When one dimention is having one to many relations with two
diffrent facts then this loop will occur. To resolve this
loop we have to use Context to chose the right path for the
reports to avoid multiple SQL statements.
Fan Tap:
Customer -> orders -> orderlines.
When one customer dimention is having one to many relation
with orders and then again orders is having one to many to
relation with orderlines then the loop will occure. To
resolve this we have to use aliase. Name the second table
oreders with some other alias name then link with third
table. Ensure to remove the link between 2nd and 3rd tables.
Hope this will answer your question.
Thanks,
Abdul
| Is This Answer Correct ? | 15 Yes | 10 No |
Post New Answer View All Answers
what is xcelsius architecture?
What is the difference between user and versatile user?
What is report template in b.o?
in sap bi we have wad, then why we go for sap bo
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What we need to discuss with designer before starting the universe designing.
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
When we use aggregate awareness function in designer?
Can more than 1 metric be applied on an analytic in business objects?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain what would you consider as your biggest achievement and why?
Explain in detail about type 1?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Differences between business objects and web intelligence reports?