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

Post New Answer




More OBIEE Interview Questions

Define repository in terms of OBIEE?

1 Answers  


How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.

1 Answers  


If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?

1 Answers  


We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?

1 Answers  


If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?

1 Answers  






What is connection pool and how many connection pools did you have in your last project?

1 Answers  


If you want to create new logical column where will you create (in repository or dashboard) why?

1 Answers  


If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  


Can you use outer join in BMM layer?

1 Answers  


What is the end to end life cycle of OBIEE?

1 Answers  


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

1 Answers  


Can you have multiple data sources in OBIEE?

1 Answers  






Categories