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

How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?

1 Answers  


Did you create any new logical column in BMM layer, how?

1 Answers  


What is authentication? How many types of authentication.

0 Answers  


Define repository in terms of OBIEE?

1 Answers  


Why do we have multiple LTS in BMM layer? What is the purpose?

1 Answers  






How will you execute direct sql in obiee?

0 Answers  


What is time series wizard? When and how do you use it?

0 Answers  


What are global filter and how they differ from column filter?

0 Answers  


What is write-back in obiee ?

0 Answers  


If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?

1 Answers  


What are the different types of security you have worked in obiee?

0 Answers  


What is complex join, and where it is used?

1 Answers  


Categories