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 ...

Get Oracle Business Intelligence 11g R1 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.