how to improve the performance of the report
Answers were Sorted based on User's Feedback
Answer / vams_gk
to inprove the performence of the reports we have multiplw
ways in my view. for example
1)generate LOV for required objects
2)use aggregate tables in universe design
3)use pre defined conditions and formulas.
4)check context (if there resolve it)
5)check loops (if there resolve it through alias table)
if u did u all these at universe level,when u generate the
report at query panel level automatically performence will
increese
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / ratnakar neti
To improve the performance of Reports we have to check the
following .
1.check the number of subreports.If more number of
subreports are there it will kill the performance of the
report
2.check the loops. We have to reduce the no.of loops to
increase the performace of report
3.generate the Lov's
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / babu
Report performane will improve by the given following
things.
1. Should disable LOv's for unnessary measure objects.
2. Create conditions at Universe level and try to reduce
the variable's and bulit complex logic's in universe and
database level.
4. use query level filters.
Is This Answer Correct ? | 0 Yes | 0 No |
U r project in which stage in implementation?
what is a filter?
What is user docs and how to use this option in bo?
What is the size of data base?
Can master data change???if yes then how it'll change.....please explain with example...... thanx
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
what is meant by report busting
How many universes will run maximum in single project
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash
how can we build one report from two data bases
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com