Answer / santhosh

Fantrap means one-to-many joins of the tables it is
detected by visval analysis. By using fantrap problem is
many rows than expected. Through aliases,context and check
mutiple sql statements for each measures option we can
solve this problem.


chasm trap means two or more many to one joins converge on
to a single lookup table

Answer / krish

Chasam Trap:

chasm trap means many-to-one and one-to-many join relation
converge on to a single lookup table, because of this we
get incorrect results i.e., cartision product, We will
resolved by using some times alias, some times context,
some times shortcut join and check mutiple context for each
measures option.

Fan Trap:

Fantrap means one-to-many and one-to-many join relation of
the tables it is detected by visval analysis, because of
this we get incorrect results i.e., cartision product,
We will resolved by using some times alias, some times
shortcut join and check mutiple sql statements for each
measures option.

Answer / shiva

these two are the loop problems
fantrap-fanning out of one to many leads to one to many
relation ships
chasamtrap-converging two fact tables into single lookup
table
fantrap can be solved by alias
chasamtrap can be solved by context

Answer / nmr

fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.

Answer / nmr

fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.

What are the diffrences between Business Objects 5.1 & 6.5 ?

1 Answers   Siemens,

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,

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 difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,

Can we have multiple domains?

3 Answers  

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

0 Answers   Infosys,

What is the Drill filter and it's usage?

2 Answers  

how to create a derived table in designer? i need steps regarding derived table

1 Answers  

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

What is the functional & architectural differences between business objects and web intelligence reports?

0 Answers  

Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,