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 ?||2 Yes||0 No|
Define repository in terms of OBIEE?
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.
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?
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?
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?
What is connection pool and how many connection pools did you have in your last project?
If you want to create new logical column where will you create (in repository or dashboard) why?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
Can you use outer join in BMM layer?
What is the end to end life cycle of OBIEE?
What are the things you can do in the BMM layer?
Can you have multiple data sources in OBIEE?