Interested to Buy Any Domain ? << Click Here >> for more details...
Example of how the fantraps and chasm traps works?
- 1 Answers
- 14775 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Tell me the difference between cmc and cms?
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?
1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?
what are cascading prompts explain with steps
Hi, How to navigate one report to another report in webi? Thanks in Advance
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
What are the join problems comes appart from loop,chasm & fan Traps
How were the reports scheduled and how to resolve unexecuted documents?
how many micro cubes can a report can have
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Difference between drill by and drill across with example?
Teradata 
