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|
Can you use physical join in BMM layer?
How do you work in a multi user environment? What are the steps?
What are the different log files in obiee?
What are the things you can do in the BMM layer?
What are the challenges you faced while making of reports?
Can you run multiple rpd’s in a single obiee instance?
Define repository in terms of OBIEE?
What is star schema and snowflake schema?
How online/offline mode impact development and delpoyment?
How the users created differs from rpd/answers/dashboards level?
What is scd type 1 and 2.
What are different types of joins that are possible in obiee rpd?