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

U r project in which stage in implementation?

0 Answers   Accenture,


what is a filter?

4 Answers  


What is user docs and how to use this option in bo?

1 Answers   Bank of Baroda,


What is the size of data base?

2 Answers  


Can master data change???if yes then how it'll change.....please explain with example...... thanx

1 Answers  






Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?

2 Answers  


what is meant by report busting

2 Answers   TCS,


How many universes will run maximum in single project

1 Answers   HP,


IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,


Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash

3 Answers  


how can we build one report from two data bases

4 Answers   IBM,


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

0 Answers  


Categories