Hi,
difference between loop and trap in business objects ?
Thanks in Advance
nvsraghu
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 |
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
what is crystal reports?how to migrate them?
How to Shedule the reports in Xi R2
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
In Business Objects 4.1 version what is the alternative name for broadcast agent?
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
normally we get many contexts when resolving loops or traps,how do u take them to reports.
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,