What are the traps ? What are the disadvantages of traps?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between user and versatile user?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Can Bo generates the Report from the cubical data Explain?
Explain in detail about type 1?
What is the dense rank?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
what are the tables used in health care domain project and columns used in report?
Explain the difference between union and group?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
how to create reports on screech?
Explain in detail about type 2(scd),
What is a fantrap in business objects?
what are the day to day activities of BO administrator ?
what is xcelsius architecture?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?