What are the traps ? What are the disadvantages of traps?
Answers were Sorted based on User's Feedback
Answer / prakash123
Traps are join problems in Universe.The disadvantage of
traps are
1)In accurate date
2)cartesian product
Cheers
Prakash
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / praveen
Traps will occur because of cardinality.
Traps are of 2 types:
1) Chasm trap
2) Fan trap
Disadvantages of traps are
More number of results
Cartesian Product
We can resolve traps by using both Alias and Contexts.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / babu
Traps are recives inacuurate data in report level, we need
to trace it by Manually.
A.Fan trap
B.Chasam TRap
A .If tables are joined as A(1:M)-->B(1:M)-->C we will get
more results than expected. through Alaias or Agg Awarenees
we can resolve. this is called as Fan trap.
tables B holds the Aggarigated values from A table then
only we will encounter fan trap is occured.
B. if tables are joined like B(m:1)<--A-->(1:m)C. This
CHASM trap can be resolved by executing separate query for
each measure and then merging the results.Use detect
context automatic tool to detect possible context in
universe and use them in order to avoid CHASM traps.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kodandapani.ancha
Traps nothing but joint path problems in the
universe..disadvantage is results is ambiquity..to resolve
| Is This Answer Correct ? | 0 Yes | 1 No |
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
is it possible to export the webi reports to crystal reports?with out using businessview?
How to check for a particular value from one column with the list of values present in another column in Webi reports?
how do u migrate BO 6.x to XI ?
52 Answers Cognizant, HCL, IBM, Wipro,
What is the sheduling the report? What is the need of sheduling the report?
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
What is the server based ranking? and its usage?
Have you worked with multiple data sources? If yes. How do you link them?
what is profile and packages in BOXI??
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
what r the universe connection types?