Interested to Buy Any Domain ? << Click Here >> for more details...
Example of how the fantraps and chasm traps works?
- 1 Answers
- 14697 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 a business scenario where I can achieve the data through MINUS only not through subquery.
Explain about a tricky situation for which you found a very simple solution?
difference between xir2 and 6.5 version
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What is the difference between the public object&schema object?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Can anybody tell me the difference b/w canned and adhoc reporting?.
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
How can you check the universe?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
how to create dashboard reports
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Teradata 
