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

Differences between business objects and web intelligence reports?

651


Give some information on report bursting?

569


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

602


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2997


Explain which versions are used in the bo dashboard work?

633






How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

574


Explain when we use aggregate awareness function in designer?

585


Explain difference between zabo and webi?

650


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1815


What is report template in b.o?

584


What would you consider as your biggest achievement and why?

616


How to open a universe with out using the Designer ??

6611


Can we configure two instances of CMS pointing to two different CMS system databases?

1485


What are the data types present in bo? What happens if we implement view in the designer and report?

618


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

588