Creating an Aggregate Storage Sample Using MaxL

Related MaxL statements: create application, create database, create outline, alter database, import data, execute aggregate process,

The following sample MaxL script creates an aggregate storage application and database based on Sample Basic.

login $1 $2;

spool on to 'maxl_log.txt';

create or replace application Sample2 using aggregate_storage 
 comment 'aggregate storage version of Sample';

create database Sample2.Basic2 
 comment 'aggregate storage version of Sample Basic';

create or replace outline on aggregate_storage database Sample2.Basic2 
 as outline on database sample.basic;

alter database Sample2.Basic2 initialize load buffer with buffer_id 1;

import database Sample2.Basic2 data 
 from server data_file 'C:\\Hyperion\\products\\Essbase\\EssbaseServer\\app\\Sample2\\Basic2\\calcdat.txt' 
 to load_buffer with buffer_id 1 
 on error abort;

import database Sample2.Basic2 data from load_buffer with buffer_id 1;

execute aggregate process on database Sample2.Basic2 
 stopping when total_size exceeds 1.9;

spool off;

logout;