Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?

Answer Posted / madhu

Find the SQL query of the report in Admin->manage Session-> view log then run the SQL query on toad if it takes the same time even in TOAD then modify the query to reduce the query time. If the query runs normally in TOAD then we need to make changes in the repository.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of security you have worked in obiee?

443


Have you created hierarchy in obiee. If so where and how?

482


What is write-back in obiee ?

482


What is a table alias in obiee? And where and how will you create it.

489


What is clusterservices in obiee ? Why its used?

481






What is a table alias in obiee 11g? Where and how will you create it?

491


What are global filter and how they differ from column filter?

507


What is a bridge table ?

469


Can you run multiple rpd’s in a single obiee instance?

420


What is star schema and snowflake schema?

513


What are the different types of variables in obiee 11g? Explain

459


How to get sql from obiee for reports?

520


How will you go about adding additional column to the repository in the presentation layer?

512


What is authentication? How many types of authentication.

470


How will you port changes for dashboards,reports,rpd from development to production?

509