What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?



What are other ways of improving summary query reports other than Aggregate Navigation and Cache Man..

Answer / 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

More OBIEE Interview Questions

What you will do when your report is not fetching right data?

0 Answers  


If you want to create new logical column where will you create (in repository or dashboard) why?

1 Answers  


How will you do different types of narrative reports in obiee?

0 Answers  


What are different types of variables? 

1 Answers  


Explain the architecture of obiee and what each components do?

0 Answers  






How online/offline mode impact development and delpoyment?

0 Answers  


How do i disable cache for only 2 particular tables?

1 Answers  


How we are going to decide which schema we are going to implement in the data warehouse?

0 Answers  


What are the things you can do in the BMM layer?

1 Answers  


How do you know which report is hitting which table, either the fact table or the aggregate table?

1 Answers  


Can you have multiple data sources in OBIEE?

1 Answers  


How analytics process your request when you create your requests?

0 Answers  


Categories