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
- 2875 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 star schema and snowflake schema?
What are the major challenges you faced while creating the rpd?
How will you execute direct sql in obiee?
What is write-back in obiee ?
Explain the architecture of obiee and what each components do?
What are the challenges you faced while making of reports?
How to enable drills in a given column data?
How to get sql from obiee for reports?
How will you port changes for dashboards,reports,rpd from development to production?
can you change the location of the obiee repository?
How will you go about adding additional column to the repository in the presentation layer?
How online/offline mode impact development and delpoyment?
How will you create report from two subject areas
How analytics process your request when you create your requests?
How to hide certain columns from a user?
