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 |
How will you do sort in reports in obiee.
How will you execute direct sql in obiee?
If you want to limit the users by the certain region to access only certain data, what would you do?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What is the end to end life cycle of OBIEE?
What is time series wizard? When and how do you use it?
What is a table alias in obiee? And where and how will you create it.
What is authentication? How many types of authentication.
What is data level security?
Why do we have multiple LTS in BMM layer? What is the purpose?
How do implement event polling table?
How we are going to decide which schema we are going to implement in the data warehouse?