Hi,
difference between loop and trap in business objects ?
Thanks in Advance
nvsraghu
- 2 Answers
- 16018 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vikram kumar
While creating or designing of universe with the designing tool like IDT or UDT we some time get errors like Loops and Traps. As per my knowledge the major difference between loops and traps is that, Loops are visible after one runs or go for integrity check while traps are in-visible in the universe design. The traps presence can only be seen while generation of reports with reporting tool like WEBI.
More to this i would also like to say that loops can be resolved by alias or use of context which depends on the scenario of the universe.
Ex - for applying context to resolve the loop, number of path depends on number of fact tables and there must be more then 1 fact table.
For alias we have to create the xerox copy of main table with a different name.
ex - suppose there are tables like country, region, sales, client and join all the 4 tables and after one go for integrity check, there would be loop formation. So, here the main table is our country, since under country, region, client and sales would be there. So, hence one have to click on country table and create alias of that like "Country_a".
Further to that, if context exist then in WEBI, it will pop out a error as -"INCOMPATIBLE CONDITION OF OBJECTS".
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain how to schedule the report in b.o?
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
When we can use multiple sql statement for each measure? and multiple sql statement for each context?
What is the size of data base?
Can any body tell me,What is the universe testing ? What is the report testing Explain?
What Is Snow Flake Schema?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
is it possible to export the webi reports to crystal reports?with out using businessview?
Teradata 
