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 / 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 |
What are the things you can do in the BMM layer?
What is connection pool and how many connection pools did you have in your last project?
How to get sql from obiee for reports?
What are the different types of security you have worked in obiee?
How many bi services node can be clustered together?
Define pipeline. Did you use it in your projects?
What is write-back in obiee ?
How do you define the relationship between facts and dimensions in BMM layer?
How will you do sort in reports in obiee.
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
What is level based metrics?
How to hide certain columns from a user?