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.

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".

When to use local filter and when to use global filter?

0 Answers  

---

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

0 Answers  

---

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,

---

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,

---

What are the steps to do to use alerts in bo?

0 Answers  

---

what are the differences between web intelligence reports and crystal reports ?

3 Answers   AG Technologies,

---

Explain the BO Developer WORK FLOW?

3 Answers   TCS,

---

4.what is repository? types

8 Answers   TCS,

---

What is aggregate table and aggregate fact table ... Any examples of both?

0 Answers  

---

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  

---

can BO generate reports with out CUBICAL data to repository?

4 Answers  

---

what is the difference between input file repository server and output file repository server ?

2 Answers   CTS,

---