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 ?    3 Yes 0 No

Post New Answer

More OBIEE Interview Questions

What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 Answers  


What is logging level? Where can you set logging levels?

1 Answers  


What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?

1 Answers  


How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?

1 Answers  


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

1 Answers  






Can you use outer join in BMM layer?

1 Answers  


How will you enable or disable caching in the system level and table level?

0 Answers  


What is star schema and snowflake schema?

0 Answers  


Explain the architecture of obiee and what each components do?

0 Answers  


How many bi services node can be clustered together?

0 Answers  


Did you create any new logical column in BMM layer, how?

1 Answers  


What is scd type 1 and 2.

0 Answers  






Categories