Create an Aggregate Storage Sample Using MaxL

You may wish to create an aggregate storage (ASO) version of a block storage (BSO) cube. The following sample MaxL script creates, loads data into, and aggregates an Essbase aggregate storage database that is based on Sample.Basic.

login $1 $2;

spool on to 'maxl_log.txt';

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

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

create or replace outline on aggregate_storage database SampleAS.Basic2 
 as outline on database Sample.Basic;

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

import database SampleAS.Basic2 data 
 from server data_file '/catalog/users/catalogUser/Data.txt' 
 to load_buffer with buffer_id 1 
 on error abort;

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

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

spool off;

logout;