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

if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode

3 Answers   HP,

---

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?

4 Answers   Infotech,

---

How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?

1 Answers   HCL,

---

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers  

---

---

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers   Exilant, Wipro,

---

I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 Answers  

---

How to fix the order of Prompts? How to assign the default value in prompt?

2 Answers   Mind Tree,

---

Can any one tell me for business objects what we need to study means some body tole me that we need DW,ETL,SQL.... is this is necessary..?

2 Answers  

---

Explain what would you consider as your biggest achievement and why?

0 Answers  

---

How we drill up week to month?

0 Answers  

---

what is meant by scorecards?

2 Answers   TCS,

---