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 |
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
how do u resolve contexts ?
Can Bo generates the Report from the cubical data Explain?
i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
WHAT IS SYNCHRONIZATION IN BOXI?
How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
What are steps to be taken care to create a good Universe?
What is the server based ranking? and its usage?
am a fresher hw to get real time experience?