Databases Reference
In-Depth Information
•
AGENTLOGMESSAGELEVEL
: Specifies to Essbase what level of detail is to be
written to system logs. The more knowledgeable you become, the less
information you will require to monitor your system, thereby keeping the
logs smaller and improving system performance.
Calculation
Here we will talk about the settings that will best help improve the run-time and
overall performance of your Essbase calculation scripts.
•
CALCCACHE
: Tells the analytic server whether to use a calculator cache. When
set to true, you can also set the
CALCCACHELOW
,
CALCCACHEDEFAULT
, and
CALCCACHEHIGH
settings that can be used in any database calculation scripts.
•
CALCLOCKBLOCK
: Specifies how many data blocks Essbase will lock at one
time during a calculation. There are mixed feelings on the setting because
a higher number of locked blocks seems like it would finish faster, but does
more and smaller chunks actually finish quicker? This is where testing and
experience come into play.
•
DYNCALCCACHEONLY
: Specifies to the analytic server if Essbase can use
memory outside of the dynamic calc memory to complete its tasks. This may
not be a good idea because Essbase may tend to wait if allowed for more
memory causing the process to actually slow down.
•
CALCPARALLEL
: This specifies how many parallel threads are allowed at one
time while calculating the data. Essbase recommends that the maximum
number of parallel threads be one less than the total number of processors on
your server. For example, if your server has 8 processors you would code 7
as your maximum number of threads to use.
° For 32 bit: Block storage option, you can select between 1 to 4
° For 64 bit: Block storage option, you can select between 1 to 8
° For Aggregate Storage option, you can select in between 1 to 8
with 2 being the default.
Syntax:
CALCPARALLEL [APPNAME] [DBNAME] N
•
EXCLUSIVECALC
: This specifies if concurrent calculations are allowed on
the same database.
Syntax:
EXCLUSIVECALC TRUE | FALSE
