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 ?||3 Yes||0 No|
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
What is logging level? Where can you set logging levels?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
What are the things you can do in the BMM layer?
Can you use outer join in BMM layer?
How will you enable or disable caching in the system level and table level?
What is star schema and snowflake schema?
Explain the architecture of obiee and what each components do?
How many bi services node can be clustered together?
Did you create any new logical column in BMM layer, how?
What is scd type 1 and 2.