what is fantrap ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain is there any other repository domains rather than universe, security, document?

587


Can we Save (save as) WEBI Doc as DESKI?

7077


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

600


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4450


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...

1626






How to execute the plsql procedure from the report by clicking with mouse?

620


Explain which versions are used in the bo dashboard work?

635


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1481


what is xcelsius architecture?

3745


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

1836


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

818


Explain is data mart?

595


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

602


how to create metric universe ?

1897


is it possible to export the webi reports to crystal reports?with out using businessview?

1820