what is fantrap and chasmtrap ?

Answer Posted / santhosh

Fantrap means one-to-many joins of the tables it is
detected by visval analysis. By using fantrap problem is
many rows than expected. Through aliases,context and check
mutiple sql statements for each measures option we can
solve this problem.


chasm trap means two or more many to one joins converge on
to a single lookup table

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1121


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4485


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1943


Explain the difference between detect alias and detect context?

794


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2834






How to create Index to the table in the universe designer and how it improves the Query performence

2311


How to execute the plsql procedure from the report by clicking with mouse?

789


Explain is there any default username & pwd for bo designer & supervisor?

773


What is a fantrap in business objects?

804


Explain about a time when you discovered a more efficient way to do a work task?

838


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

791


how to create metric universe ?

2077


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

748


Can Bo generates the Report from the cubical data Explain?

1803


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2593