Answer / prakash123

Traps are join problems in Universe.The disadvantage of
traps are
1)In accurate date
2)cartesian product



Cheers
Prakash

Answer / praveen

Traps will occur because of cardinality.

Traps are of 2 types:
1) Chasm trap
2) Fan trap

Disadvantages of traps are
More number of results
Cartesian Product

We can resolve traps by using both Alias and Contexts.

Answer / guest

fan trap and chasem trap

Answer / babu

Traps are recives inacuurate data in report level, we need
to trace it by Manually.

A.Fan trap
B.Chasam TRap

A .If tables are joined as A(1:M)-->B(1:M)-->C we will get
more results than expected. through Alaias or Agg Awarenees
we can resolve. this is called as Fan trap.
tables B holds the Aggarigated values from A table then
only we will encounter fan trap is occured.

B. if tables are joined like B(m:1)<--A-->(1:m)C. This
CHASM trap can be resolved by executing separate query for
each measure and then merging the results.Use detect
context automatic tool to detect possible context in
universe and use them in order to avoid CHASM traps.

Answer / kodandapani.ancha

Traps nothing but joint path problems in the
universe..disadvantage is results is ambiquity..to resolve

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  

What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????

2 Answers   Infosys, Keane India Ltd,

What is the stored procedure ? What is the need of stored procedure ? How to create a stored procedure Universe?

1 Answers   HCL,

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,

What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

3 Answers   Wipro,

What is the Computation error? how to solv it?

1 Answers  

Have you worked with multiple data sources? If yes. How do you link them?

1 Answers  

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

0 Answers  

Explain about Short cut join?

2 Answers   Wipro,

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,