By default, when cells with identical keys are loaded into the same data load buffer, Essbase resolves the cell conflict by adding the values together.
To create a data load buffer that combines duplicate cells by accepting the value of the cell that was loaded last into the load buffer, use the alter database MaxL statement with the aggregate_use_last grammar.
For example:
alter database AsoSamp.Sample initialize load_buffer with buffer_id 1 property aggregate_use_last;
Note: | When using data load buffers with the aggregate_use_last grammar, data loads are significantly slower, even if there are not any duplicate keys. |