To create an optimized Essbase database, ask:
How does your company use the data?
How will you build and order the dimensions?
Which data compression scheme will you use?
How will you create and order calculations?
See these topics:
Planning the development of your multidimensional database, see Case Study: Designing a Single-Server, Multidimensional Database.
Selecting dense and sparse dimensions, see Selection of Dense and Sparse Dimensions.
Loading data, see Understanding Data Loading and Dimension Building.
Compressing data and optimizing your database, see Data Compression.
Calculating your database, see Calculating Essbase Databases.