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

Working with Common Platform Language (CPL)

CPL is the syntax that you will need to use on your data elements or dimension elements to apply functions, filters, and operators. In this recipe, we will use the MonthShortName function and concatenate data elements using CPL.

Getting ready

To get started with Essbase Studio, click on the Start menu and Programs | Oracle EPM System | Essbase | Essbase Studio. The login menu will pop up. Enter your server, username, password, and click on the Log in button.

How to do it…

  1. In Essbase Studio, on the right side of your screen, you will see two tabs. Click on the Minischema tab, click and hold the MEASURES folder, and drag it under the MetaData Navigator root directory. Repeat the same step for the SALES folder. ...

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