Stored Levels in an Aggregate Storage Outline

It is not always possible to derive disk space requirements of an Essbase aggregate storage (ASO) cube based on the number of cells. Not all dimension levels are stored. Knowing the number of stored levels can help you manage the storage requirements.

To calculate the number of stored dimension levels in an outline:

1. Determine the stored-level factor for each dimension.
2. Multiply the dimension factors together; for example, a * b * c * d, and so on.

To determine the stored-level factor for each dimension, use the following guidelines:

• On dynamic dimensions, the factor is 1.

• On stored dimensions, for an initial dimension factor, count the non-label-only levels.

  • If a stored dimension has attribute dimensions, count the levels in each attribute dimension, and add that number to the dimension factor. Then, if all level 0 members of the dimension have an attribute from a specific attribute dimension, subtract 1 for each attribute dimension in which this occurs.

  • If a stored dimension has additional stored hierarchies, count the number of non-label-only levels in each stored hierarchy, and add the count to the dimension factor. Do not count a level if it comprises only shared members.

  • Dynamic hierarchies in a stored dimension do not affect the dimension factor.

For example, multiplying the factors for the 11 dimensions in ASOsamp.Basic, 1 * 1 * 4 * 2 * 2 * 2 * 3 * 2 * 6 * 7 * 7 equals 56,448.

To view dimension level factors, use the query database MaxL statement with the keywords list aggregate_storage runtime_info. Example:

query database ASOSamp.Basic list aggregate_storage runtime_info;