Executing calculations using MaxL

In this recipe, we will create a calculation script with a MaxL script command and then execute that calculation with a MaxL script that takes a set of parameters for portability. You should complete the recipe Setting up folder structure and other files needed for MaxL automation before you continue as we are going to need the folder structure and scripts created in that recipe.

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 or replace calculation Sample2.Basic.CalcAll
   'SET UPDATECALC OFF; 
   SET CLEARUPDATESTATUS AFTER; 
   SET AGGMISSG ON; 
   SET LOCKBLOCK HIGH; 
   SET CACHE ALL; 
   SET CACHE HIGH; 
   SET...