O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

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

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

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