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

Answer Posted / srikanth

Remove unnecessary objects and variables if any.make sure
you remove alerters if any unless it is the
requirement.Take the report query and run in Database.See
how much time its taking.From report query check whether
in 'where' clause columns have indexes.If not discuss with
oracle admin and add indexes.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is universe null

1991


Explain how many universes can be created in a project?

620


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1974


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

593


What is the difference between datawarehousing and businessintelligence?

622






Explain when we use aggregate awareness function in designer?

590


how get the grand total in master-detail report?

1819


What is package in BO

2687


Explain what sort of existing documents should business analysts refer to when starting on a new project?

607


What is the difference in creating filters in designer and business objects?

592


how many reports have u created ? explain a few.

1667


Explain is there any other repository domains rather than universe, security, document?

587


What is top business?

569


Explain what are the steps to do to use alerts in bo?

617


What Is The Difference Between Oltp And Olap?

682