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
What is a bridge table ?
What are different types of joins that are possible in obiee rpd?
What are the different types of variables in obiee? Explain
How will you enable or disable caching in the system level and table level?
Explain the architecture of obiee and what each components do?
what is guided navigation?
What is level based metrics.how will you create it?
What is star schema and snowflake schema?
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?
How analytics process your request when you create your requests?
How will change port of obiee answers?
What you will do when your report is not fetching right data?
How we are going to decide which schema we are going to implement in the data warehouse?
How will you do different types of narrative reports in obiee?
How online/offline mode impact development and delpoyment?