OneStream Community

rmichaelsmi · 07-27-2023

What I have found is that using the BRApi.Finance.Members.GetMemberInfo or Metadata.GetMember calls with True for includeProperties or even the first call to BRApi.Finance.UD.Text(...) all incur an average of just over 2 seconds and we are looping th...

rmichaelsmi · 08-01-2023

I had looked at that briefly, but wasn't sure of the true impact of the nocache. Sounds like it would be worth a try as I would expect most of the Text fields to remain somewhat static once initially corrected. Limiting the cost to only when an updat...

rmichaelsmi · 07-27-2023

I timed around every call and it is the ones I shared. We pull the ids so we know those. Hitting the backend just to see what has changed may be the way we have to go. I do not want to update that way as there is supposed to be history, logging, etc ...

rmichaelsmi · 07-27-2023

See above EDITED section for some more context. We do an initial pull from OneStream using the GetMembersUsingFilter in which we get the MemberInfo Object and use IDs from there. That function is very fast. The slow part is in retrieving and updating...

rmichaelsmi · 07-27-2023

See new EDITED context. We pull the text field values from a sql table and are comparing to what is in OneStream and updating. The text field values are from an external source.

OneStream Community

User Statistics

User Activity

updating a lot of UD Text# fields is taking forever, what is a faster way?

Re: updating a lot of UD Text# fields is taking forever, what is a faster way?

Re: updating a lot of UD Text# fields is taking forever, what is a faster way?

Re: updating a lot of UD Text# fields is taking forever, what is a faster way?

Re: updating a lot of UD Text# fields is taking forever, what is a faster way?