MDXINSERTBUFFERAGGMETHOD

This Essbase configuration setting defines how the output buffer should be created for an MDX Insert request on the cube.

Syntax

MDXINSERTBUFFERAGGMETHOD ADD | LAST

LAST—If, during an Insert operation, a value needs to be written to an output buffer location that already contains a value, the latest value overwrites the older value.
ADD—If, during an Insert operation, a value needs to be written to an output buffer location that already contains a value, the latest value is summed with the older value. This is the default behavior.

Description

During execution of the MDX Insert query, an output buffer is created in memory which accumulates with values until the query is completed. This setting enables you to define the method with which values are aggregated in the output buffer. The method that you use can have an effect on the data results of the MDX Insert operation.

Assume that in an MDX Insert query, two source tuples are mapped to a single target tuple, as shown:

INSERT
([Payroll], [Jan]) TO ([Revised Payroll], [Jan])
([Payroll], [Feb]) TO ([Revised Payroll], [Jan])
...

Assume that the value of ([Payroll], [Jan]) is 100, and the value of ([Payroll], [Feb]) is 200.

Using the default buffer aggregation behavior (ADD),

MDXINSERTBUFFERAGGMETHOD ADD

The value for ([Payroll], [Jan]) is written to the output buffer for ([Revised Payroll], [Jan]), making its value 100.
The value for ([Payroll], [Feb]) is added to the same output buffer for ([Revised Payroll], [Jan]), increasing its value to 300.

If you change the buffer aggregation behavior to LAST,

MDXINSERTBUFFERAGGMETHOD LAST

The value for ([Payroll], [Jan]) is written to the output buffer for ([Revised Payroll], [Jan]), making its value 100.
The value for ([Payroll], [Feb]) is written to the same output buffer for ([Revised Payroll], [Jan]), overwriting the previous value, and changing it to 200.