Answer / abdul

Chasm trap and Fan Traps are the loops which will occur
while ditecting loops.

Examples of these are:

Chasm Trap:

Orders
Customer <
Sales

When one dimention is having one to many relations with two
diffrent facts then this loop will occur. To resolve this
loop we have to use Context to chose the right path for the
reports to avoid multiple SQL statements.

Fan Tap:

Customer -> orders -> orderlines.

When one customer dimention is having one to many relation
with orders and then again orders is having one to many to
relation with orderlines then the loop will occure. To
resolve this we have to use aliase. Name the second table
oreders with some other alias name then link with third
table. Ensure to remove the link between 2nd and 3rd tables.

Hope this will answer your question.

Thanks,
Abdul

I have saved one file in GMT as a standard time and the server must convert it into local time. How to do it?

1 Answers   IBM,

---

wat is difference b/w break and section?

4 Answers  

---

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

3 Answers   Collabera,

---

how do u resolve contexts ?

6 Answers   Wipro,

---

is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   CTC, TCS,

---

What is ment by For each For all function. In which case we use the option in BO?

2 Answers   IBM, TCS,

---

Explain which versions are used in the bo dashboard work?

0 Answers  

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

---

what are the all possible reasons of getting partial result on a webi report?

3 Answers   L&T,

---

i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?

4 Answers   Cap Gemini,

---

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers  

---

There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?

2 Answers  

---