Essbase.CFG Configuration Settings


Alphabetical List

AGENTDELAY
AGENTDISPLAYMESSAGELEVEL
AGENTLOGMESSAGELEVEL
AGENTPORT
AGENTTHREADS
AGGRESSIVEBLKOPTIMIZATION
AGTSVRCONNECTIONS
AUTHENTICATIONMODULE
CALCCACHE
CALCCACHEHIGH
CALCCACHEDEFAULT
CALCCACHELOW
CALCLIMITFORMULARECURSION
CALCLOCKBLOCK
CALCMODE
CALCNOTICE
CALCOPTFRMLBOTTOMUP
CALCREUSEDYNCALCBLOCKS
CALCPARALLEL
CALCTASKDIMS
CCTRACK
CLEARLOGFILE
CRASHDUMP
CSSREFRESHLEVEL
CSSSYNCLEVEL
DATACACHESIZE
DATAERRORLIMIT
DATAFILECACHESIZE
DELAYEDRECOVERY
DELIMITEDMSG
DELIMITER
DEPLOYMENTID
DIRECTIO
DISKVOLUMES
DISPLAYMESSAGELEVEL
DLSINGLETHREADPERSTAGE
DLTHREADSPREPARE
DLTHREADSWRITE
DYNCALCCACHEBLKRELEASE
DYNCALCCACHEBLKTIMEOUT
DYNCALCCACHECOMPRBLKBUFSIZE
DYNCALCCACHEMAXSIZE
DYNCALCCACHEONLY
DYNCALCCACHEWAITFORBLK
ESSBASELICENSESERVER
EXCEPTIONLOGOVERWRITE
EXCLUSIVECALC
EXPORTTHREADS
GRIDEXPANSION
GRIDEXPANSIONMESSAGES
HAENABLE
HAMAXNUMCONNECTION
HAMAXNUMSQLQUERY
HAMAXQUERYROWS
HAMAXQUERYTIME
HAMEMORYCACHESIZE
HARAGGEDHIERARCHY
HARETRIEVENUMROW
HASOURCEDSNOS390
IBHFIXTHRESHOLD
IMPLIEDSHAREONMINUS
INCRESTRUC
INDEXCACHESIZE
JVMMODULELOCATION
LOCKTIMEOUT
LOGINFAILUREMESSAGEDETAILED
LOGMESSAGELEVEL
LROONSHAREDMBR
MAXLOGINS
MEMSCALINGFACTOR
MULTIPLEBITMAPMEMCHECK
NETBINDRETRYDELAY
NETDELAY
NETRETRYCOUNT
NETTCPCONNECTRETRYCOUNT
NODENAME
NOMSGLOGGINGONDATAERRORLIMIT
NUMERICPRECISION
OPGCACHESIZE
OUTLINECHANGELOG
OUTLINECHANGELOGFILESIZE
PARCALCMULTIPLEBITMAPMEMOPT
PIPEBUFFERSIZE
PORTINC
PORTUSAGELOGINTERVAL
PRELOADALIASNAMESPACE
PRELOADMEMBERNAMESPACE
QRYGOVEXECBLK
QRYGOVEXECTIME
SECURITYFILECOMPACTIONPERCENT
SERVERPORTBEGIN
SERVERPORTEND
SERVERTHREADS
SET COPYMISSINGBLOCK
SHAREDSERVICESLOCATION
SHAREDSERVICESREFRESHINTERVAL
SILENTOTLQUERY
SQLFETCHERRORPOPUP
SSAUDIT
SSAUDITR
SSLOGUNKNOWN
SSPROCROWLIMIT
SUPNA
TARGETASOOPT
TARGETTIMESERIESOPT
TIMINGMESSAGES
TRIGMAXMEMSIZE
UNICODEAGENTLOG
UPDATECALC
VLBREPORT

Change-History List

New Settings in Release 9.0

Miscellaneous
CSSREFRESHLEVEL
CSSSYNCLEVEL
DEPLOYMENTID
SHAREDSERVICESLOCATION
SHAREDSERVICESREFRESHINTERVAL

New Settings in Release 7.2

Calculation Optimization
AGGRESSIVEBLKOPTIMIZATION

New Settings in Release 7.1.2

Miscellaneous
ANALYTICSERVERID
ESSBASELICENSESERVER
LOGINFAILUREMESSAGEDETAILED

New Settings in Release 7.1

Outline Paging
OPGCACHESIZE
PRELOADALIASNAMESPACE
PRELOADMEMBERNAMESPACE
Miscellaneous
IMPLIEDSHAREONMINUS
SECURITYFILECOMPACTIONPERCENT
SILENTOTLQUERY
TARGETASOOPT
VLBREPORT
Hybrid Analysis
HASOURCEDSNOS390

New Settings in Release 7.0

Unicode
UNICODEAGENTLOG
Console Message Level
DISPLAYMESSAGELEVEL
AGENTDISPLAYMESSAGELEVEL
Query Optimization
TARGETTIMESERIESOPT
Monitoring Data Using the Triggers Feature
TRIGMAXMEMSIZE
Controlling Free Space Recovery
DELAYEDRECOVERY

Removed Settings in Release 7.0

Calculation Hash Tables
CALCHASHTBLMEMORY CALCOPTCALCHASHTBL

Aggregate Storage List

The following settings apply only to aggregate storage databases.

OPGCACHESIZE
PRELOADALIASNAMESPACE
PRELOADMEMBERNAMESPACE

The following settings are relevant to aggregate storage databases and to block storage databases.

AGENTDELAY
AGENTDISPLAYMESSAGELEVEL
AGENTLOGMESSAGELEVEL
AGENTPORT
AGENTTHREADS
AGTSVRCONNECTIONS
AUTHENTICATIONMODULE
CALCPARALLEL
CLEARLOGFILE
CRASHDUMP
CSSREFRESHLEVEL
CSSSYNCLEVEL
DATAERRORLIMIT
DELIMITEDMSG
DELIMITER
DISPLAYMESSAGELEVEL
DLSINGLETHREADPERSTAGE
DLTHREADSPREPARE
EXCEPTIONLOGOVERWRITE
GRIDEXPANSION
GRIDEXPANSIONMESSAGES
HAENABLE
HAMAXNUMCONNECTION
HAMAXNUMSQLQUERY
HAMAXQUERYROWS
HAMAXQUERYTIME
HAMEMORYCACHESIZE
HARAGGEDHIERARCHY
HARETRIEVENUMROW
HASOURCEDSNOS390
JVMMODULELOCATION
LOGINFAILUREMESSAGEDETAILED
LOGMESSAGELEVEL
MAXLOGINS
NETBINDRETRYDELAY
NETDELAY
NETRETRYCOUNT
NODENAME
NOMSGLOGGINGONDATAERRORLIMIT
NUMERICPRECISION
OUTLINECHANGELOG
OUTLINECHANGELOGFILESIZE
PIPEBUFFERSIZE
PORTINC
PORTUSAGELOGINTERVAL
QRYGOVEXECTIME
SECURITYFILECOMPACTIONPERCENT
SERVERPORTBEGIN
SERVERPORTEND
SERVERTHREADS
SHAREDSERVICESLOCATION
SILENTOTLQUERY
SQLFETCHERRORPOPUP
SSAUDIT
SSAUDITR
SSLOGUNKNOWN
SSPROCROWLIMIT
SUPNA
TARGETTIMESERIESOPT
TIMINGMESSAGES
TRIGMAXMEMSIZE
UNICODEAGENTLOG

The following settings apply only to block storage databases, and are not relevant to aggregate storage databases.

AGGRESSIVEBLKOPTIMIZATION
CALCCACHE
CALCCACHEHIGH
CALCCACHEDEFAULT
CALCCACHELOW
CALCLIMITFORMULARECURSION
CALCLOCKBLOCK
CALCMODE
CALCNOTICE
CALCOPTFRMLBOTTOMUP
CALCREUSEDYNCALCBLOCKS
CALCTASKDIMS
CCTRACK
DATACACHESIZE
DATAFILECACHESIZE
DELAYEDRECOVERY
DIRECTIO
DISKVOLUMES
DLTHREADSWRITE
DYNCALCCACHEBLKRELEASE
DYNCALCCACHEBLKTIMEOUT
DYNCALCCACHECOMPRBLKBUFSIZE
DYNCALCCACHEMAXSIZE
DYNCALCCACHEONLY
DYNCALCCACHEWAITFORBLK
EXCLUSIVECALC
EXPORTTHREADS
IBHFIXTHRESHOLD
IMPLIEDSHAREONMINUS
INCRESTRUC
INDEXCACHESIZE
LOCKTIMEOUT
LROONSHAREDMBR
MULTIPLEBITMAPMEMCHECK
PARCALCMULTIPLEBITMAPMEMOPT
QRYGOVEXECBLK
SET COPYMISSINGBLOCK
UPDATECALC
VLBREPORT