Aggregate Storage Database Limits

Table 238 lists limits related to aggregate storage databases.

Table 238. Aggregate Storage Limits

Artifact

Limits

Number of hierarchies in a single dimension of an aggregate storage database

65535 (including all stored hierarchies, dynamic hierarchies, and any attribute dimensions based on the dimension)

Number of members in an aggregate storage outline

10,000,000 to 20,000,000 members, depending on available memory and other memory requirements

Maximum file location size in an aggregate storage database

4,294,967,295 MB

Number of stored dimension level combinations in an aggregate storage outline

The product of dimension level factors across stored dimensions cannot exceed 252, which is equal to 4,503,599,627,370,496.

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 factor for each dimension, use the following guidelines:

  • For dynamic dimensions, the factor is 1.

  • For stored dimensions, for an initial dimension factor, count the nonlabel-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 nonlabel-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.Sample, 1 * 1 * 4 * 2 * 2 * 2 * 3 * 2 * 6 * 7 * 7 equals 56,448.

To view dimension level factors:

  • In Administration Services Console, right-click a database, select Edit, and then Properties. On the Statistics tab, under Aggregate storage statistics, each non-attribute dimension in the outline is listed, showing the number of stored levels (which is the dimension level factor) in each dimension. For example:

    Dimension [Products] has [6] levels, bits used 7
  • Use this MaxL command:

    query database appName.dbName list aggregate_storage runtime_info;

Maximum number of cells that can be queried in an aggregate storage database that has a very sparse data set

264

The limit is based on the number of cells that Essbase processes in the query, which is the product of the member count across all dimensions, not on the number of cells contained in the output report.

You might encounter this limit when using a client interface (such as Oracle Hyperion Financial Reporting) that suppresses missing data in order to generate a relatively small report compared to the size of the query.

Number of alias tables

32

Number of parallel export threads

8

For information about how Essbase uses export threads, see the data export MaxL command for block storage database and the EXPORTTHREADS configuration setting in the Oracle Essbase Technical Reference.