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