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 level-based hierarchies

Before starting this task, logical dimension and fact tables should be created in the BMM layer. In addition to this, logical joins should exist including logical keys. If these are not ready, then you should create the logical tables, set the logical table sources, and complete all other tasks that are specified in Chapter 1, Exploring and Building the Repository.

How to do it...

  1. First, we're going to create the logical dimension with a level-based hierarchy. Right-click on Business Model and select the New Object and Logical Dimension options. Then select the Dimension with Level-Based Hierarchy option.
    How to do it...
  2. The Logical ...

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