Interested to Buy Any Domain ? << Click Here >> for more details...
Example of how the fantraps and chasm traps works?
- 1 Answers
- 14843 Views
- IBM, I also Faced
- E-Mail Answers
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
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Can we configure two instances of CMS pointing to two different CMS system databases?
What would you consider as your biggest achievement and why?
what is universe null
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Can we Save (save as) WEBI Doc as DESKI?
Can you please send me the migration related issues .
When to use local filter and when to use global filter?
Explain what would you consider as your biggest achievement and why?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How many universes can be created in a project?
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 ?
What is thumbnail?
What task is 98% of the required work of a business analyst?
