Answer / the_xxx

There are two main types of connection traps:

1. fan traps
2. chasm traps

Fan traps

A fan trap occurs when a model represents a relationship
between entity types, but the pathway between certain entity
occurrences is ambiguous. It occurs when 1:m relationships
fan out from a single entity.

Missing ALT text
Figure : Fan Trap

A single site contains many departments and employs many
staff. However, which staff work in a particular department?

The fan trap is resolved by restructuring the original ER
model to represent the correct association.

Missing ALT text
Figure : Resolved Fan Trap

Chasm traps

A chasm trap occurs when a model suggests the existence of a
relationship between entity types, but the pathway does not
exist between certain entity occurrences.

It occurs where there is a relationship with partial
participation, which forms part of the pathway between
entities that are related.

Missing ALT text
Figure : Chasm Trap

* A single branch is allocated many staff who oversee
the management of properties for rent. Not all staff oversee
property and not all property is managed by a member of staff.
* What properties are available at a branch?
* The partial participation of Staff and Property in the
oversees relation means that some properties cannot be
associated with a branch office through a member of staff.
* We need to add the missing relationship which is
called `has' between the Branch and the Property entities.
* You need to therefore be careful when you remove
relationships which you consider to be redundant.

Answer / divakar

There will be traps w.r.t query joins in FM. They are when
1. there is infinite relation existing between query
subjects like A->B->C->A
2. there is ambiguous relationship(No proper relationship)
Then there will be traps while running the query or w.r.t.
data.

what is meant by roll up and roll back in dataware housing????

4 Answers   Covansys, IBM, Wipro,

---

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers   DELL,

---

-------------How to do Bursting a Report?

1 Answers   Cap Gemini,

---

hi friends pls forward impropmtu interview question

0 Answers  

---

Use of Text Source Variable in Report Studio?

2 Answers  

---

Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:

3 Answers  

---

Can you define snapshot?

0 Answers  

---

How many reports did you create in your project?

3 Answers   IBM,

---

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

1 Answers  

---

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

---

Explain what is the difference between microstrategy and cognos reporting tool?

0 Answers  

---

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

---