Hi,
difference between loop and trap in business objects ?

Thanks in Advance
nvsraghu

Answer Posted / gs2kumar@gmail.com

Loop is a continues path between the tables trap also is a kind of loop Due to oracle limitation some time it give multiple duplicate values when 3
tables join continuously with 1-N and 1-N and Cartesian
product also occurs. To resolve the traps and loops we should use alias, context and shortcut join. We can find the loops by checking Integrity check in Universe but can be find by view only, to resolve the fan trap better to go for alias and for chasm trap context.

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the dense rank?

671


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

814


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1745


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4180


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

691






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

506


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1718


Explain the difference between detect alias and detect context?

620


what is xcelsius architecture?

3738


what is the difference b/w the refresh and buffered data?

1759


what is universe null

1986


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)?

571


Is there any other repository domains rather than universe, security, document?

593


Explain how to schedule the report in b.o?

561


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

621