When creating Essbase database structures, you need to consider many factors, such as the order of the Essbase outline, whether the dimensions should be set as dense or sparse, and how to optimize the Essbase caches.
See the following sections for a brief description of some Essbase settings:
The best resource for information about optimizing Essbase is the Oracle Essbase Database Administrator's Guide which is available from the Oracle Technology Network (http://www.oracle.com/technology/documentation/epm.html). In particular, review the suggestions in “Improving Essbase Performance.”