Essbase : Multiple SQL Data Loads in Parallel to Aggregate Storage Databases

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!

Essbase Member Properties for Dimension Builds

When building an Essbase dimension build file, 99% of the time, I will build it using a Parent / Child relationship.  I feel its the easiest to maintain and shared members are added automatically.  Here's a simple example for the Scenario dimension:

Scenario|Actual|+|
Scenario|Budget|~|
Scenario|Forecast|~|
Scenario|Revised Forecast|~|

In case you were wondering what the + and ~ mean or need more properties, here's a good list for you:

Essbase Member Properties for Aggregate Storage Database

% Set consolidation to express as a percentage of current total.
* Set consolidation to multiply by the current total
+ Set consolidation to add to the current total