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
The new business model can be found in the following screenshot:
How to do it...
- Again ...