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

Setting Essbase properties

In this recipe, we will use the Essbase Properties dialog to set up the default Alias table, set the dense and sparse setting for our dimensions, select all external source properties for the MEASURES dimension, and specify the attribute types for the MARKET and PRODUCT dimensions. We will also use the Transformation tab to add a suffix to the STATE metadata member in the SUPPLIER, so that it does not overlap with the MARKET dimension's STATE metadata member.

Getting ready

To get started, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Essbase Studio and log in to Essbase Studio using your server, username, and password.

How to do it…

  1. Right-click on the TBCModel created in recipe Developing ...

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