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

Building a Measures dimension from the fact table

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.

Getting ready

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

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