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|
How do i disable cache for only 2 particular tables?
Can you have multiple data sources in OBIEE?
How do you know which report is hitting which table, either the fact table or the aggregate table?
Can you bypass siebel analytics server security ?if so how?
Can you use outer join in BMM layer?
Define repository in terms of OBIEE?
What is query repository tool?
Why do we have multiple LTS in BMM layer? What is the purpose?
If you want to create new logical column where will you create (in repository or dashboard) why?
What is object level security?
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?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?