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
What we need to discuss with designer before starting the universe designing.
Explain what is the difference between slice and dice and cross tab report?
What Is Snow Flake Schema?
What are the steps to be taken to schedule the report?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
When to use local filter and when to use global filter?
What are the steps to do to use alerts in bo?
What is object stores?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Can you please send me the migration related issues .
What is the functional & architectural differences between business objects and web intelligence reports?
What is the difference between absolute and relative div positioning?
What task is 98% of the required work of a business analyst?
Explain what is aggregate table and aggregate fact table ... Any examples of both?