what is fantrap ?
Answers were Sorted based on User's Feedback
Answer / kishore pothuri
A fan trap is a type of join path between three tables when
a “one-to-many”
join links a table which is in turn linked by another “one-
to-many” join. The
fanning out effect of “one-to-many” joins can cause
incorrect results to be
returned when a query includes objects based on both tables.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / prasanna.ramesh1
when there is one-to-many jointo a table that "fans out"
into another "one- to-many" join to another table.this
problem is called fan trap.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vijay
A fan trap is a table between three tables when A one to
many join links a table which is in turn linked by another
one to many join.the fanning out effect of "one-to-many
joins can cause incorrect results to be returned when a
query includes objects based on both tables
| Is This Answer Correct ? | 1 Yes | 0 No |
the fan trap is let we take 3 tables the 1 table is joined to
2 table with 1 : N Cordinality and 2 table is joined to 3 table with 1 : N cordinality
I.e 1.....(1:N)......2....(1:N).....3
then it it forming a fan trap.
it does through any errors but the the required data will not get corectly
so by using alias we can resolve this traps
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kvchowdary
if a table which is going to connect some other table with
one- to- many cardinalities which is having cardinalities
with some other tables
| Is This Answer Correct ? | 0 Yes | 1 No |
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
. In production reports, some dimensions are missing. how do you load these dimensions in production
HOW TO HIDE Column in WEBI & DESKI?
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
How to sheduling the report ? What is the need of it?
while migrate bo 5.1 report into boxir2 ,what are the problems faced
how can i add two different reports in the same document?
What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?
What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?
5.what is LOV? where it is store?
WHO ARE THE USERS OF THE REPOSITORY?
What is the user Object ? What is the need of it?