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
How analytics process your request when you create your requests?
What you will do when your report is not fetching right data?
What is a table alias in obiee 11g? Where and how will you create it?
How many bi services node can be clustered together?
How will you do different types of narrative reports in obiee?
What is time series wizard? When and how do you use it?
What is clusterservices in obiee ? Why its used?
How will you execute direct sql in obiee?
How the users created differs from rpd/answers/dashboards level?
What are the different log files in obiee?
What are the major challenges you faced while creating the rpd?
From where u get the logical query of your request?
What is level based metrics.how will you create it?
How will change port of obiee answers?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?