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 to hide certain columns from a user?
Can you have multiple data sources in OBIEE?
How will change port of obiee answers?
If you want to limit the users by the certain region to access only certain data, what would you do?
Have you created hierarchy in obiee. If so where and how?
How will you create report from two subject areas
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
How the users created differs from rpd/answers/dashboards level?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
How to enable drills in a given column data?
How to sort columns in rpd and web?
Define pipeline. Did you use it in your projects?