Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 2977 Views
- I also Faced
- E-Mail Answers
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 ? | 4 Yes | 0 No |
How online/offline mode impact development and delpoyment?
What are the different types of security you have worked in obiee?
How to sort columns in rpd and web?
What are the different layers of obiee repository?
How do you know which report is hitting which table, either the fact table or the aggregate table?
How we are going to decide which schema we are going to implement in the data warehouse?
What is the purpose of Alias Tables?
How will you execute direct sql in obiee?
What is a table alias in obiee? And where and how will you create it.
What is data level security?
Define repository in terms of OBIEE?
How do you define the relationship between facts and dimensions in BMM layer?
Teradata 
