Example of how the fantraps and chasm traps works?
Answer / 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 |
Can any one gve me the complete information abt Certfication of Business Objects ?
what is diff between webi,deski,infoview
how to create reports on screech?
what is casual dimension?
Explain is there any other repository domains rather than universe, security, document?
when will use compatible and incompatible objects?
1 Answers Business Intelligence Analytics, iGate, TCS,
Can i merge two dataproviders if they do not have common column?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?
Did you face any problems while creating reports? Name? Solutions?