Forum Discussion

Marcello's avatar
Marcello
Contributor
3 years ago

api.Data.SetDataBuffer in increment mode

Hi all, we have a databuffer with values to be cumulated in a specifi destination intersection. The issue we have is that api.Data.SetDataBuffer always wirte the last value. Is there a standard...
Finance
  • Marcello's avatar
    Marcello
    3 years ago

    Hi Giacomo,

    we had a call with a Onestream consultant

    The final outcome is that we agreed that the best way to handle cumulation is to use the "evergreen" api.Data.GetDataCell and  "api.Data.Calculate" (while looping records in the databuffer).

    This give us 2 advantages:

    - we can instruct the calculation with element names rather than the IDs

    - we can debug the calculation line by line

    Thanks a lot for the help.

    Marcello

     

Marcello's avatar
Marcello
Contributor
3 years ago

Hi Marc,

sorry how many commas do I need to put? Is it the "isDurableCalculatedData" that makes the cumulate?

Thanks,

Marcello

 

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    3 years ago

    I think Marc is talking about dataBufferObj.setCell(newValue, accumulateIfCellAlreadyExists) - that second parameter is a boolean. That method allows you to accumulate values in a single cell of the buffer.

    So you will still have to loop through cells, but you can avoid having to retrieve existing numbers.

    Note that you can also simply sum two buffer objects together, e.g.

    Dim resultBuf as DataBuffer = originalBuffer + newValuesBuffer