O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Best practices of the analyses and the dashboards

The queries that are executed against the data warehouses cause a large amount of database processing. Every time we access an analysis, the query is going to be generated by the BI server and it's executed against the database. Let's assume that a dashboard contains many analyses that will cause intensive calculations. When the business users access that dashboard, all the analyses will run. This will impact the performance. We should not publish many objects in the main dashboards. The users should see the results as quickly as possible. We can achieve this by publishing summary result sets in the main dashboards. If they are interested in the finer granular levels, they can drill down or navigate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required