About Aggregate Storage Cubes

Consider using the aggregate storage model if the following is true for your database:

• The database is sparse and has many dimensions, and/or the dimensions have many levels of members.

• The database is used primarily for read-only purposes, with few or no data updates.

• The outline contains no formulas except in the dimension tagged as Accounts.

• Calculation of the database is frequent, is based mainly on summation of the data, and does not rely on calculation scripts.

Some MaxL grammar is applicable to aggregate storage mode, and some MaxL grammar is not relevant. To learn which statements are supported in aggregate storage application and database operations, see MaxL Statements (Aggregate Storage).