The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

kchampion's avatar
kchampion
New Contributor III
1 year ago
Solved

SetDataCellsUsingMemberScript does not write all list items

Hello All, SetDataCellsUsingMemberScript() seems to only write the last value added to list.  I am successfully adding 14 records to the objMemberScriptValues list (I can loop through them and see ...
Extenders
Finance
  • MarcusH's avatar
    MarcusH
    1 year ago

    You need to move this line to be before the For loop starts:

    Dim objMemberScriptValues As New List(Of MemberScriptAndValue)

     

Krishna's avatar
Krishna
Valued Contributor
1 year ago

The For Loop Next should be after the End If, then it will write all the values!!!!

  • kchampion's avatar
    kchampion
    New Contributor III
    1 year ago

    Correct, it does, but it commits one row at a time, which is very inefficient.  I was looking for a way to write all the rows to the list in memory and commit them all at once to improve performance.