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.
See Also