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.

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.

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

Answer / ramesh

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

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

limitaions of cross tab ?

1 Answers  

I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help

1 Answers  

When is the Repository created?

1 Answers  

Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?

2 Answers   Accenture,

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers  

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

0 Answers   Arkema pte Ltd,

how to create dashboard reports

4 Answers   TCS,

7.what is data mart?

7 Answers   TCS,

Any one suggest me best SAP Business Objects XI Online Training institute from India

2 Answers   Aetna,

which is the best way to resolve loop context r alias why?

3 Answers