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…
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.
Right-click on the SALES folder, click on New, and then Dimension Element:
Change the name to
MonthShortName, select the Function tab, drill down on All functions, and click on the monthShortName function. Click on the Source tab and highlight $...
