Adding attribute dimensions to hierarchies
In this recipe, we are going to set up the PRODUCT dimension that we discussed in the recipe Determining hierarchies in relational tables in Chapter 1, Understanding and Modifying Data Sources. We discussed the theory behind the one-to-one or one-to-many relationship of a hierarchy in Chapter 1. In contrast, we will create the base dimension PRODUCT and its attribute dimensions in this recipe.
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, drill down on the TBC Minischema, select the PRODUCT(s) folder, and drag the folder to the Metadata Navigator. Repeat the same exercise for the FAMILY and SALESMAN folder created...
