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
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Differences between business objects and web intelligence reports?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain in detail about type 1?
What Is The Difference Between Oltp And Olap?
In banking domain how many Fact tables,Dimension table are present?
Explain what is the difference between slice and dice and cross tab report?
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)?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is Indexing? how did u implement indexing?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
any difficulitis have you phase while creating bo reports and how did u solve it
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?
What sort of existing documents should business analysts refer to when starting on a new project?
