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

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.