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
- 3028 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
From where u get the logical query of your request?
How to startup obiee in linux?
What are the different types of variables in obiee? Explain
What is a bridge table ?
What is write-back in obiee ?
What is time series wizard? When and how do you use it?
What are different types of joins that are possible in obiee rpd?
can you change the location of the obiee repository?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How will you go about adding additional column to the repository in the presentation layer?
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 are the challenges you faced while making of reports?
What you will do when your report is not fetching right data?
What are the major challenges you faced while creating the rpd?
