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

Kamila's avatar
Kamila
Contributor
2 years ago

GetDataBuffer takes too much time to process

Dear Team, I'm trying to understand what caused the low performance of my code. I see that it's because of many loops, but I'm wondering if there's any possible way to fix it: Dim ResultDataB...
Finance
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

The immediate suggestion would be to use FilterMembers instead of looping through accounts and ICs:

Dim sourceBuffer as DataBuffer = api.Data.GetDataBufferUsingFormula( _
    "FilterMembers(RemoveZero(A#All:O#Forms:U1#Whatever:etcetc), A#account1, A#account2, I#ic1, I#ic2, [etc etc]")

If you really want, you can then loop through the records in that buffer to set all cells to zero.