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

How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?

1 Answers  

---

can anybody tell me how many classes where there and objects in each class

3 Answers  

---

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

---

What is a category?

3 Answers  

---

Explain what sort of existing documents should business analysts refer to when starting on a new project?

0 Answers  

---

Instead of cms which server you have to use?

2 Answers   CTS,

---

Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important

7 Answers   Zylog,

---

without creating the business view is there possible to create & generate the Crystal reports?

3 Answers   TCS,

---

filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers   IBM,

---

How to check for a particular value from one column with the list of values present in another column in Webi reports?

2 Answers  

---

When we are going for Shortcut join and why.

1 Answers   Cap Gemini,

---

Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  

---