Executing partitions using MaxL

In recipe, we will create a copy of the Sample2.Basic database, create a partition, and execute the partition to move data from Sample2.Basic to our new application using MaxL. You should complete the Setting up folder structure and other files needed for MaxL automation and Executing Dimension Build Rules using MaxL in this chapter as we will need the AUTOMATION folder structure and the dimensions built.

Getting ready

To get started, click on the Start menu and navigate to Program | 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. In EAS, click on File, click on Editors, click on MaxL Script Editor, type the following MaxL script, and click on the Execute Script button.

   /*Create an application Sample4 as a copy of Sample2*/
   create application Sample4 as Sample2;
   
   /*Clear the new Sample4.Basic database*/
   alter database Sample4...