how to improve the performance of the report

Answers were Sorted based on User's Feedback



how to improve the performance of the report..

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

how to improve the performance of the report..

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

how to improve the performance of the report..

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

Post New Answer

More Business Objects Interview Questions

What is thumbnail?

0 Answers  


Can any please explain FOR EACH AND FOR ALL?

2 Answers   HCL, Infosys, TCS,


What is difference between merged dimension and forced dimension??

1 Answers  


in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level

3 Answers   Accenture,


difference between xir2 and 6.5 version

4 Answers  






Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  


can i link two Universes having with different connection

3 Answers  


I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

39 Answers   TCS,


what is the diff between etl tool and olap tool

2 Answers  


How to restrict the user to refresh or Run the report only 1 time in BO?

6 Answers   Perot Systems,


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.

7 Answers   Satyam,


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

3 Answers  


Categories