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 ? | 4 Yes | 0 No |
What are the different types of variables in obiee 11g? Explain
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
You worked on standalone or integrated system?
How many bi services node can be clustered together?
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 to sort columns in rpd and web?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
How will you port changes for dashboards,reports,rpd from development to production?
What is object level security?
What is authentication? How many types of authentication.
Do you know about Initialization Blocks? Can you give me an example where you used them?
What are the different layers of obiee repository?