Databases Reference
In-Depth Information
Following we have an example of an actual
essbase.cfg
file. As you can see, you
can place comments anywhere in the file by beginning the line with a semi-colon.
Multiple comment lines require each line to begin with a semi-colon. Statement
lines are simply the statement itself, followed by a space, then the parameter. The
statement line itself does not need to be terminated by a period or semi-colon as
other scripts in Essbase need to.
Although it does not say this is mandatory anywhere in the Essbase documentation,
we have always kept the statement entries in the
essbase.cfg
file all uppercase so
there is no confusion as to what character is what.
; +++++++++++++++++++++++++++++++++++++++++++++
; Begin Essbase configuration file for the ESSCAR server
;
; Dynamic calc support for the ESSCAR application
; due to large numbers of members being dynamically calculated
DYNCALCCACHEONLY ESSCAR FALSE
DYNCALCCACHEWAITFORBLK ESSCAR FALSE
;
; Sets the max number of error rows to be written from
; any single data load or process
DATAERRORLIMIT 5000
;
; Allows the use of DIRECT I/O when possible
DIRECTIO TRUE
;
; Sets the number of blocks locked by a database calculation
; and corresponds to the setting in the calc script itself
CALCLOCKBLOCKHIGH 50000
CALCLOCKBLOCKDEFAULT 30000
CALCLOCKBLOCKLOW 10000
;
; Sets the delay time and number of retries allowed for a connection
; to the analytic server
NETDELAY 2000
NETRETRYCOUNT 4000
;
; Allows the use of a database calculator cache
CALCCACHE TRUE
;
; Sets the size of the calculator cache for high, default and low
; cache sizes. Use of cache size determined in calc script
CALCCACHEHIGH 200000000
CALCCACHEDEFAULT 100000000
