what is fantrap ?

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1570


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

1969


Explain which versions are used in the bo dashboard work?

633


Explain the difference between union and group?

625


What would you consider as your biggest achievement and why?

615






Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

598


what will be the contents for a functional requirements specifications

1782


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

637


When we use aggregate awareness function in designer?

548


What is difference between custom hierarchy and report based hierarchy?

549


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

540


What three things do you consider to be the most important factors for a manager?

592


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

1816


What is the difference between condition & filter?

605


When to use local filter and when to use global filter?

601