Example of how the fantraps and chasm traps works?



Example of how the fantraps and chasm traps works?..

Answer / 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

More Business Objects Interview Questions

What is batch processing in Business Objects?

2 Answers  


what is variable ?

3 Answers   Tech Mahindra,


can anybody tell me about complicated object you have created

0 Answers  


What is difference between merged dimension and forced dimension??

1 Answers  


What is the difference between business requirement document and use case document.

0 Answers  






WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,


what are the debuggings in the business objects?

1 Answers   IBM,


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  


What are the different types of connections?Explain?

1 Answers   Wipro,


How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".

3 Answers  


What are different types of saving options in web intelligence?

7 Answers  


REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers  


Categories