What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
Answer Posted / karthis4u
Doing performnce tuning in DB side.In obiee side,updating etting in connection pool or creating seperate connection pool for authorisation and heavy tables/aggregate tables.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can you run multiple rpd’s in a single obiee instance?
How to startup obiee in linux?
What is a bridge table ?
How to get sql from obiee for reports?
What are the different types of security you have worked in obiee?
What are the different types of variables in obiee 11g? Explain
How many bi services node can be clustered together?
Have you created hierarchy in obiee. If so where and how?
How will you enable or disable caching in the system level and table level?
What is write-back in obiee ?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How to enable drills in a given column data?
How will you execute direct sql in obiee?
How will you go about adding additional column to the repository in the presentation layer?
can you change the location of the obiee repository?