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 |
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
what is the source for metrics?
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
how many times can use the union operator in a report?
5.what is LOV? where it is store?
How to create Universe using Flat file in BO6.0
How to open a universe with out using the Designer ??
Explain how many universes can be created in a project?
WHO ARE THE USERS OF THE REPOSITORY?
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu