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 |
what do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
How to generate the report from excel sheet?
what is diff between Decode and case ? Give some Example?
how can we overcome by loops?and also is it possible ,one user can different universe
while migrate bo 5.1 report into boxir2 ,what are the problems faced
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
What are the types of errors you faced while creating a report from two different data providers
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
IS THERE ANY MINIMUM RQUIREMENT TO DEFINE CONTEXT?
What are different types of saving options in web intelligence?