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 are the different types of security you have worked in obiee?
Have you created hierarchy in obiee. If so where and how?
What is write-back in obiee ?
What is a table alias in obiee? And where and how will you create it.
What is clusterservices in obiee ? Why its used?
What is a table alias in obiee 11g? Where and how will you create it?
What are global filter and how they differ from column filter?
What is a bridge table ?
Can you run multiple rpd’s in a single obiee instance?
What is star schema and snowflake schema?
What are the different types of variables in obiee 11g? Explain
How to get sql from obiee for reports?
How will you go about adding additional column to the repository in the presentation layer?
What is authentication? How many types of authentication.
How will you port changes for dashboards,reports,rpd from development to production?