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;