Example of how the fantraps and chasm traps works?
Answer Posted / abdul
Chasm trap and Fan Traps are the loops which will occur
while ditecting loops.
Examples of these are:
Chasm Trap:
Orders
Customer <
Sales
When one dimention is having one to many relations with two
diffrent facts then this loop will occur. To resolve this
loop we have to use Context to chose the right path for the
reports to avoid multiple SQL statements.
Fan Tap:
Customer -> orders -> orderlines.
When one customer dimention is having one to many relation
with orders and then again orders is having one to many to
relation with orderlines then the loop will occure. To
resolve this we have to use aliase. Name the second table
oreders with some other alias name then link with third
table. Ensure to remove the link between 2nd and 3rd tables.
Hope this will answer your question.
Thanks,
Abdul
| Is This Answer Correct ? | 15 Yes | 10 No |
Post New Answer View All Answers
In banking domain how many Fact tables,Dimension table are present?
How many universes can be created in a project?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Can we Save (save as) WEBI Doc as DESKI?
How were the reports scheduled and how to resolve unexecuted documents?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain about alerts in bos, under what situation we need to use alerts?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Can you please send me the migration related issues .
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain difference between zabo and webi?
What is top business?
what are the day to day activities of BO administrator ?