A default essbase.cfg file exists in the Essbase bin directory.
To edit the essbase.cfg configuration file:
Enter each setting on a separate line in the file. Semicolon terminators are not required.
After editing the configuration file, perform the proper action to have the configuration file reread:
If the setting applies to the server, stop and restart Essbase Server.
If the setting applies to a specific application, stop the application (if it is running) and restart it.
If the setting applies only to a database, restart the application.
Oracle recommends that you make there are no duplicate settings in the essbase.cfg file.
You can override many essbase.cfg values using:
MaxL statements
Administration Services dialogs
ESSCMD commands
When you use MaxL or Administration Services to change essbase.cfg values, many values are effective immediately. See the Oracle Essbase Database Administrator's Guide for details.
Some essbase.cfg settings affect performance. Before you override Essbase defaults, see information about performance optimization and storage settings in the Oracle Essbase Database Administrator's Guide
essbase.cfg settings apply to all databases unless the values are noted as database- or application-specific.
Essbase uses the keywords and their unparsed values "as is." No syntax check is performed.
You can use an essbase.cfg file on the client to override Essbase default network settings. Only the following settings can be used in an essbase.cfg client file:
All other configuration settings are intended for the server essbase.cfg file only.
The following is an example of essbase.cfg server file entries:
SSPROCROWLIMIT 20000 LOCKTIMEOUT 1200
See the Oracle Essbase Database Administrator's Guide.