Creating hierarchies using a generation reference table
In this recipe, we will be using a SUPPLIER table, created in a generation reference, to build the SUPPLIER dimension. The SUPPLIER dimension has a geographical hierarchy. A geographical hierarchy is a natural hierarchy, which makes it an excellent candidate for a generation reference table.
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 the Minischema node, drill down on the TBC minischema, select the SUPPLIER folder, and drag the folder to the Metadata Navigator.
Right-click on the Root directory under the Metadata Navigator, click on New, and then on Folder. Enter
HIERARCHIES
in the name textbox for the folder in the Properties...