Creating hierarchies using a parent-child reference table
In this recipe, we will build a hierarchy using a parent-child reference. The parent-child reference is the most flexible format for building hierarchies. In this recipe, we will work with the MEASURES dimension as this table in the TBC database is set up in a parent-child format.
Getting ready
To get started, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Studio. The login menu will pop up. Enter your server, username, and password, and click on the Log in button.
How to do it…
On the right side of your Essbase Studio screen you are going to see two tabs. Click on the Minischemas tab, drill down on Minischema node, and double-click on TBC Minischema.
In the Minischema window, right-click on the MEASURES table. Then click on Add Joins…. Select MEASURES in the combobox on the right and click on the PARENT metadata element from the following drop-down list.
On the left column, select CHILD from the...
