Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?



Suppose I have report which is running for about 3 minutes typically. What is the first step you tak..

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

Post New Answer

More OBIEE Interview Questions

Can you use physical join in BMM layer?

1 Answers  


How do you work in a multi user environment? What are the steps?

1 Answers  


What are the different log files in obiee?

0 Answers  


What are the things you can do in the BMM layer?

1 Answers  


What are the challenges you faced while making of reports?

0 Answers  






Can you run multiple rpd’s in a single obiee instance?

0 Answers  


Define repository in terms of OBIEE?

1 Answers  


What is star schema and snowflake schema?

0 Answers  


How online/offline mode impact development and delpoyment?

0 Answers  


How the users created differs from rpd/answers/dashboards level?

0 Answers  


What is scd type 1 and 2.

0 Answers  


What are different types of joins that are possible in obiee rpd?

0 Answers  


Categories