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

Difference between drill by and drill across with example?

4 Answers   TCS, WNS,

---

IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,

---

What is Indexing? how did u implement indexing?

0 Answers   TCS,

---

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

0 Answers   Polaris,

---

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

---

What Is Snow Flake Schema?

0 Answers   Informatica,

---

what is traffic lighting in business objects?

1 Answers  

---

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers   Cap Gemini, Infinity, TCS,

---

can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?

3 Answers  

---

what is the source for metrics?

2 Answers  

---

How were the reports scheduled and how to resolve unexecuted documents?

0 Answers  

---

In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,

---