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 Presentation layer

The Presentation layer holds the subject areas, presentation tables, and presentation columns. They are all exposed to the end users through the Presentation Services (web user interface). All the objects in this layer depend on the BMM layer objects.

Subject areas should be created based on Roles. We should always think from the user perspective when it comes to designing the subject areas. We can also set the permissions on the objects so that every user logged in to Presentation Services won't be able to access them.

How to do it...

  1. Create role-based subject areas based on the business requirements. You can see the sample design in the following screenshot:
  2. We should list the dimension tables first, and ...

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