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 |
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
every reports have docid,when i export a report docid will change or not?
What are the difference between merge,auto merge and extended merge ?
can we cretae views in universe level?
I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process
What is the report extension in webi and deski
Explain how we drill up week to month?
What is pragma?
Which versions are used in the bo dashboard work?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
main purpose of aggregate awareness(not include make possible of use of aggregate tables)