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 |
What is thumbnail?
Can any please explain FOR EACH AND FOR ALL?
What is difference between merged dimension and forced dimension??
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
difference between xir2 and 6.5 version
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
can i link two Universes having with different connection
I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM
what is the diff between etl tool and olap tool
How to restrict the user to refresh or Run the report only 1 time in BO?
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report