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

Explain how we drill up week to month?

825


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

804


What is the difference between business requirement document and use case document.

772


How to restrict password to a user while sending a document in .pdf format

2046


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

2171


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1799


How to schedule the report in b.o?

745


what will be the contents for a functional requirements specifications

2047


What would you consider as your biggest achievement and why?

786


Give some information on report bursting?

745


Which versions are used in the bo dashboard work?

765


Explain difference between zabo and webi?

839


What is the difference between condition & filter?

1154


Can we create universe with no cache??

2156


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

788