Answer Posted / 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

Differences between business objects and web intelligence reports?

1126

---

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

2233

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2369

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10259

---

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

1952

---

In banking domain how many Fact tables,Dimension table are present?

8743

---

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

924

---

What is difference between custom hierarchy and report based hierarchy?

954

---

What is the profile and package?

2251

---

What task is 98% of the required work of a business analyst?

981

---

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2130

---

can anybody tell me about complicated object you have created

3174

---

Can you please send me the migration related issues .

2032

---

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

966

---

Explain how many universes can be created in a project?

1011

---