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