Databases Reference
In-Depth Information
•
SET CACHE HIGH/DEFAULT/LOW/OFF/ALL
: In the Essbase configuration file,
if you have specified values for the
CALCCACHELOW
,
CALCCACHEHIGH
, and
CALCCACHEDEFAULT
, then when you run a database calculation script you
set the calculator memory cache to
HIGH
,
LOW
, or
DEFAULT
. When you preset
these values in the script (as needed), you can realize a better performance
while the script is executing.
The Essbase configuration file is stored in the Essbase program directory
on the server. This file can contain many entries for tweaks and adjustments
that help your Essbase system perform better. The Essbase Configuration
ile is explained in more detail in Chapter 9 of this topic.
Let us say the following are the settings for the calc cache in the Essbase
configuration file. Oops! We introduced a new term here. The Essbase
configuration file is new and we have not talked about it yet. Well, we
will discuss the configuration file in the coming chapters. However, for
now know that it is a file where you can set up your server settings and
adjustments which improve the overall performance of data loads
and data calcs.
Now, where were we? Oh yes, the server calc cache settings:
CALCCACHEHIGH 150000000
CALCCACHEDEFAULT 100000000
CALCCACHELOW 50000000
In the Calculation Script you have defined:
SET CACHE HIGH;
This command sets the calculator cache to 150,000,000 bytes.
SET CACHE DEFAULT;
This command sets the calculator cache to 100,000,000 bytes.
SET CACHE LOW;
This command sets the calculator cache to 50,000,000 bytes.
•
SET CALCTASKDIMS n
: Specifies the number of
Sparse
dimensions that can
run in parallel, where n is maximum number of
Sparse
dimensions. This
command can help speed up the performance of a calculation script by
identifying tasks or transactions that can be run in parallel instead of serially.
SET CALCTASKDIMS 1
In the above command, the last
Sparse
dimension is identified as the task
that can run in parallel.
•
SET CALCPARALLEL n
: Enables the calculation tasks to run in parallel, where
n
is number of threads. The value of
n
can be 1 to 4 for 32 bit and 1 to 8 for 64
bit servers.
SET CALCPARALLEL 4
