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 do you implement security using External Tables and LDAP?
Define repository in terms of OBIEE?
What is a table alias in obiee 11g? Where and how will you create it?
How do implement event polling table?
How will change port of obiee answers?
What is scd type 1 and 2.
Explain the architecture of obiee and what each components do?
What are the major challenges you faced while creating the rpd?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
You worked on standalone or integrated system?
can you change the location of the obiee repository?
How online/offline mode impact development and delpoyment?