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 |
what are the tables used in health care domain project and columns used in report?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?
How to create Universe using Flat file in BO6.0
How to execute the plsql procedure from the report by clicking with mouse?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
could you please give me the diagram of BO 6.5 Architecture or explain about the tires?
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
why do we use crystal reports rather than webintelligence reports ?
what is incompactabulity error in sap bo