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 universe null
Explain what task is 98% of the required work of a business analyst?
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...
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?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain difference between zabo and webi?
What is the difference between the public object&schema object?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Give some information on report bursting?
What is difference between webi and infoview?
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...
Can Bo generates the Report from the cubical data Explain?
Is there any other repository domains rather than universe, security, document?
Can we configure two instances of CMS pointing to two different CMS system databases?
What are the steps to do to use alerts in bo?