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 many bi services node can be clustered together?
How will you go about adding additional column to the repository in the presentation layer?
What are the different types of security you have worked in obiee?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What are global filter and how they differ from column filter?
How do you implement security using External Tables and LDAP?
can you change the location of the obiee repository?
What is object level security?
What is scd type 1 and 2.
What is a table alias in obiee? And where and how will you create it.
From where u get the logical query of your request?
What is the end to end life cycle of OBIEE?