This is the big one! The essbase.cfg
file is where most of your advanced techniques will come into play. The essbase.cfg
file is an ASCII text file and can be edited using any standard text editing tool. Found on the Essbase analytic server in the essbase\bin
folder, the heart and soul of your performance tuning will be in there. In fact, many of the performance tuning settings the you will set through the EAS will have a counterpart setting in the essbase.cfg
file.
Note
A word to the wise:
Always make a backup copy of the essbase.cfg
file before you make any changes to it. The essbase.cfg
file is a critical system file used by the Essabse analytic server, and there are entries in there that affect whether the service will start or not. Just in case.
First of all, there are literally dozens of optional statements that can be used in the essbase.cfg
file as shown in the screenshot below. However, do not be alarmed, if you do not have each of the available...