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
- 3037 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 we are going to decide which schema we are going to implement in the data warehouse?
What is level based metrics?
What you will do when your report is not fetching right data?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
What are the different layers of obiee repository?
How will you create interactive dashboards ?
How will you create report from two subject areas
How to hide certain columns from a user?
What is the end to end life cycle of OBIEE?
Can you use outer join in BMM layer?
How to enable drills in a given column data?
Teradata 
