To create an optimized database, ask:

• How does your company use the data?

• How will you build and order the dimensions?

• 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 Overview of Data Load and Dimension Build.

• Calculating your database, see Calculate Essbase Block Storage Databases.