Databases Reference
In-Depth Information
Well, you know that a multi-threaded process will execute faster than a
single-threaded process. You also know that there are specific data load settings
that you can use in the essbase.cfg file that may help alleviate this performance
issue. Then, you remember that you read about the
DLSINGLETHREADSPERSTAGE
,
DLTHREADSPREPARE
, and
DLTHREADSWRITE
settings that can be coded in the
essbase.cfg
file. These settings allow you to set up your data loads to use
multiple-threading while processing. You quickly make the appropriate entries
in the
essbase.cfg
file, restart your server, and start your data load process
again. You are now amazed and happy that the data load processes to completion
significantly faster.
Just remember these now familiar words on your long and exciting Essbase journey,
"Essbase is an art, not a science."
Next up, we jump into a discussion on a relatively new database structure concept.
First rolled out with Hyperion Essbase version 7.x, the Aggregate Storage Option
(ASO) is an option that is gaining considerable ground as a means to provide your
business customer with superior system performance, while still delivering the
expected Essbase level of data quantity, quality, and integrity.
