Most of the time,
loading Essbase data from SQL Server in
serial mode works just fine:
alter
database EssApp.EssDb initialize load_buffer with buffer_id 1;
import
database EssApp.EssDb data
connect
as SQLUser identified by SQLPswd
using
server rules_file 'Load.rul' to
load_buffer with buffer_id 1
on
error write to 'errorfile.err';
import database ASOsamp.Sample data
from load_buffer with buffer_id 1;
But if you have a lot of SQL data loads that take a
long time, you might run into complaints from your client to speed of the data
load process. Well, your in luck!