what is fantrap and chasmtrap ?

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

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to schedule the report in b.o?

564


Explain how to schedule the report in b.o?

567


how get the grand total in master-detail report?

1819


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

935


What are the steps to be taken to schedule the report?

558






8. How much supervision have you typically received in your previous job?

1836


What we need to discuss with designer before starting the universe designing.

1822


Explain what are the steps to be taken to schedule the report?

639


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1628


how to create metric universe ?

1897


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

999


Explain the difference between union and group?

632


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2403


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

607


Can Bo generates the Report from the cubical data Explain?

1628