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

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers  

---

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

0 Answers  

---

What is pragma?

1 Answers  

---

Can more than 1 metric be applied on an analytic in business objects?

0 Answers  

---

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

2 Answers   Wipro,

---

how to restrict up to three levels in hierarchy when u do drill mode?

3 Answers   iGate,

---

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

0 Answers  

---

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers   Infosys,

---

Can any one say me wat does"maintanence of universe" means wit?

2 Answers   Business Intelligence Analytics, NAL, TCS,

---

WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers   HCL,

---

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

0 Answers  

---