AUTOMERGEMAXSLICENUMBER

This Essbase configuration setting specifies the maximum number of incremental data slices that can exist in a data load without activating the process of automatically merging incremental data slices. When the value of AUTOMERGEMAXSLICENUMBER is exceeded, the auto-merge process is activated.

Note:

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

This setting applies only to aggregate storage databases.

Syntax

AUTOMERGEMAXSLICENUMBER n

n—Specifies the maximum number of incremental data slices that can exist in a data load without activating the process of automatically merging incremental data slices.

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 auto-merge process is activated.

The default value is 0.

During the auto-merge 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 incremental data slice is added to the list of incremental data slices to be automatically merged
Greater than r, the incremental data slice is not added to the list of incremental data slices to be automatically merged

Example

AUTOMERGEMAXSLICENUMBER 5

Activates the incremental data slice auto-merge process when the number of incremental data slices exceeds 5.