In this recipe, we will build a Measures dimension from a column in the ASOsamp fact table. The ASOsamp fact table has measures as columns instead of rows. For this reason, the Measures dimension in the ASOsamp star schema is not in its own table, and we have to build its structure in Essbase Studio. We will have to define formulas and other Essbase Properties, but this is done after we build the Cube Schema and Essbase Model.
To get started with Essbase Studio, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Studio, then click on Start Server to make sure your Essbase Studio Server is running. When the Start Server command prompt gives you the console command, log in to Essbase Studio using your server, username, and password.