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

If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?

1 Answers  


How will you port changes for dashboards,reports,rpd from development to production?

0 Answers  


How analytics process your request when you create your requests?

0 Answers  


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

0 Answers  


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

1 Answers  


How to hide certain columns from a user?

0 Answers  


What is a bridge table ?

0 Answers  


What is write-back in obiee ?

0 Answers  


What are different types of joins that are possible in obiee rpd?

0 Answers  


What is level based metrics?

1 Answers  


Can you run multiple rpd’s in a single obiee instance?

0 Answers  


Can you have multiple data sources in OBIEE?

1 Answers  


Categories