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
What is clusterservices in obiee ? Why its used?
What is a table alias in obiee? And where and how will you create it.
How will you port changes for dashboards,reports,rpd from development to production?
What are the different types of variables in obiee 11g? Explain
How to startup obiee in linux?
How will you enable or disable caching in the system level and table level?
What is a table alias in obiee 11g? Where and how will you create it?
How will you do sort in reports in obiee.
Explain the architecture of obiee and what each components do?
How we are going to decide which schema we are going to implement in the data warehouse?
How will change port of obiee answers?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
What are the challenges you faced while making of reports?
Have you created hierarchy in obiee. If so where and how?
What is a bridge table ?