Database optimization checklist

From The Essbase Wiki

Quite often, a process is too slow or needs to be sped up. Although the data-load or calculation aspect may be consuming most of the time, it's still very useful to profile all of the steps in the process.