AUTOMERGEMAXSLICENUMBER

The Essbase configuration setting AUTOMERGEMAXSLICENUMBER specifies the maximum number of incremental data slices that can exist in a aggregate storage (ASO) data load without activating an automatic merge. When the value of AUTOMERGEMAXSLICENUMBER is exceeded, the automerge is activated.

Note:

To use the AUTOMERGEMAXSLICENUMBER configuration setting, the AUTOMERGE configuration setting must be set to SELECTIVE or ALWAYS.

AUTOMERGEMAXSLICENUMBER configuration applies only to ASO databases, and does not apply to block storage (BSO) databases.

Syntax

AUTOMERGEMAXSLICENUMBER n

n—Specifies the maximum number of incremental data slices that can exist in an ASO data load without activating an automatic merge.

When the number of incremental data slices is equal to or less than n, the incremental data slices are not merged.
When the number of incremental data slices is greater than n, the automerge process is activated.

The default value of AUTOMERGEMAXSLICENUMBER is 0.

During the automerge process, Essbase determines the maximum size, as a percentage, that any one incremental data slice can contribute to the maximum number of incremental input cells. Essbase counts the number of cells in all committed incremental data slices. Assume that r represents the maximum percentage. If the size of an incremental data slice, as a percentage, is:

Equal to or less than r, the slice is added to the automerge list.
Greater than r, the slice is not added to the automerge list.

Example

AUTOMERGEMAXSLICENUMBER 5

Activates the automerge process when the number of incremental data slices exceeds 5.