Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 2968 Views
- I also Faced
- E-Mail Answers
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 level based metrics.how will you create it?
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?
How the users created differs from rpd/answers/dashboards level?
What is a table alias in obiee 11g? Where and how will you create it?
What is write-back in obiee ?
What are the different types of security you have worked in obiee?
Can you run multiple rpd’s in a single obiee instance?
What is authentication? How many types of authentication.
How many bi services node can be clustered together?
can you change the location of the obiee repository?
How will change port of obiee answers?
What is scd type 1 and 2.
What is a table alias in obiee? And where and how will you create it.
What are the key configuration files in obiee?
What you will do when your report is not fetching right data?
