Deploy dimension created in Essbase Studio

In this recipe, we will deploy the Time dimension from an Essbase model created in Chapters 2 and Chapter 3 with MaxL scripts. The ability to deploy one dimension at a time is new in version 11.1.2.1. Prior to this version, you only had the option of deploying the entire cube. This functionality gives us a lot more flexibility as in real world situations it is normally not practical or necessary to deploy the entire cube every time you have to make changes to a single hierarchy.

Getting ready

To get started, click on the Start menu and navigate to Programs | Oracle EPM System | Essbase | Start Administration Services Console. In the Log in menu, enter your Administration Server, Username, Password, and click on the Log in button.

How to do it...

1. Click on the File menu, click on Editors, click on MaxL Script Editor, enter the following outline, and click on the Execute script button.

   /*Create TBC2 application*/
   create application 'TBC2';
   
   /*Create TBC2...