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

Performance and security tips

Business users shouldn't access all of the analyses in Presentation Services. We should set the permissions of the catalog objects so that users can only access the analyses that they need from a business perspective. We can enforce security settings in the repository and also in the Presentation Catalog.

Besides security, query performance is another issue in the BI projects. Whenever analyses run, they should display the results quickly. For instance, generating one result set in an hour is not acceptable. We should tune the performance in such cases to satisfy the business goals.

How to do it...

  1. Grant only the privileges required for business users in Presentation Catalog. You can set permissions for all of the catalog ...

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