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 parent-child hierarchies

In order to demonstrate the creation of the logical dimension with parent-child hierarchies, we're going to use another data source and another business model. So three new tables are imported into the Physical layer. And all the physical joins and keys are defined. Additionally, a new business model is created and the logical joins are also created in the Business Model diagram. So all the prerequisite steps are done before creating the parent-child hierarchy. You'll notice that there's a logical table called EmployeeManagers and there're 2 columns that will be used in the example. These columns are EMPLOYEE_ID and MANAGER_ID.

The new business model can be found in the following screenshot:

How to do it...

  1. Again ...

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