Using ASO incremental data loads

In this recipe, we will set up a MaxL script to create a data load buffer, load data into that buffer, and merge the incremental slice created. The ASOsamp.Sample database was created in Chapter 5 recipe Using MDX in aggregate storage applications. This recipe is only for the aggregate storage application.

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. Copy the LDASO.rul file and LoadSample.txt to .\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\app\ASOSamp\Sample\.

2. 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.

   /* 
   Variables sent from command file: 
    1 Host (Server) 
    2 User Name 
    3 Password 
    4 App name 
    5 Database Name...