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
Explain about a task that really tested your analytical abilities?
Explain when to use local filter and when to use global filter?
What is report template in b.o?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Can Bo generates the Report from the cubical data Explain?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what three things do you consider to be the most important factors for a manager?
Is there any other repository domains rather than universe, security, document?
How were the reports scheduled and how to resolve unexecuted documents?
U r project in which stage in implementation?