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
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What are the steps to do to use alerts in bo?
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)?
What is aggregate table and aggregate fact table ... Any examples of both?
What is a fantrap in business objects?
Explain is there any default username & pwd for bo designer & supervisor?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain the difference between union and group?
What is the difference between business requirement document and use case document.
How to restrict password to a user while sending a document in .pdf format
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Differences between business objects and web intelligence reports?
What is the difference in creating filters in designer and business objects?
What Is Snow Flake Schema?
Explain what are the measure objects?