Essbase provides default values for some database storage settings in the essbase.cfg file. You can leave the default settings or change their values in two places:
You can define storage settings for all databases on the Essbase Server by changing values in the essbase.cfg file.
You can define storage settings for a single database by using any of the methods specified in Specifying and Changing Database Settings.
Changes made for an individual database permanently override essbase.cfg settings and Essbase defaults for the relevant database until they are changed or withdrawn.
If you use MaxL or Administration Services Console to change settings at the database level, the changes become effective at different times, as shown in Table 152:
Table 152. Database Setting Precedence
The first time after setting these values that there are no active transactions | |
If you manually change these database settings in essbase.cfg, you must stop and restart the relevant application to make them effective.