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

Creating presentation hierarchies

In the OBIEE 10g, this feature was not supported. Exposing the hierarchies enables end users to learn about the levels of the dimensions without drilling down. This feature is introduced with OBI 11g.

How to do it...

  1. We're going to just drag the Customer dimension on to the Customer Presentation table. You'll see that the hierarchy is exactly the same as it is on the BMM layer.
    How to do it...
  2. We'll repeat the same task for the Product dimension as well. After that we'll have all the hierarchies at the Presentation layer. Now users will be able to use the hierarchies in their analyses.

How it works...

  1. Now it's time to check these hierarchies ...

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