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 what are the steps to do to use alerts in bo?
Explain what would you consider as your biggest achievement and why?
how many reports have u created ? explain a few.
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
how to create reports on screech?
Explain how many universes can be created in a project?
what will be the contents for a functional requirements specifications
What is a bo repository?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is difference between custom hierarchy and report based hierarchy?
When to use local filter and when to use global filter?
What is aggregate table and aggregate fact table ... Any examples of both?
how to prepare the documentation in business objects and where to get the requirement?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...