Number of members in a block storage outline

Approximately 1,000,000 explicitly defined members in an Essbase outline.

Longer member names, which can occur if using multibyte characters, decrease the number of members that are allowed.

Number of possible cells per block in a block storage database

64-bit: 2²⁸ -1 (268,435,455)

Number of possible sparse blocks in a block storage database

The product of the stored, dynamic, and never share member counts of sparse dimensions cannot exceed the following value:

64-bit: 2¹⁰⁴

Blocks for members of the type store and never share are stored. Blocks for members of the type dynamic calc are dynamically calculated, and they contribute to the number of possible sparse blocks. Shared members (including implied share) and label only members do not contribute.

The product of member counts is tracked using two 64-bit numbers. The product of member counts of sparse dimensions is taken in the order in which they are defined in the outline. Whenever the product exceeds 2⁵² on the first 64-bit number, there is a rollover to the second 64-bit number, where the product tracking starts again at 0 and goes up to 2⁵².

If the second number hits the 2⁵² limit, you will encounter an Essbase block limit error. To avoid this, try rearranging the sparse dimensions in a different order in the outline so as to accommodate the products of the member counts without reaching the 2⁵² limit.

Number of Linked Reporting Objects in a block storage database

64-bit: 2¹⁰⁴

Number of alias tables

56

Number of parallel export threads

1024

For information about parallel export, see the export data MaxL statement.

Number of dimensions in a block storage outline

254