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 do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,


IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,


How to generate the report from excel sheet?

0 Answers  


what is diff between Decode and case ? Give some Example?

2 Answers  


how can we overcome by loops?and also is it possible ,one user can different universe

4 Answers  






while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 Answers  


how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,


What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,


What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?

1 Answers   NSE,


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

0 Answers  


IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?

2 Answers   Clover, Rolta,


What are different types of saving options in web intelligence?

7 Answers  


Categories