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
updating a lot of UD Text# fields is taking forever, what is a faster way?
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 a...
JackLacava
OneStream Employee
OneStream EmployeeChances are that the Dimension Library does some caching when the application is first open, and/or uses internal methods to speed up things. It then probably uses something like GetAllMembers.
2 seconds for a GetMemberInfo seems a bit high anyway... do you use IDs?
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 the Text Fields.
Depending on which way I tried, calling the Members.GetMemberInfo or the Metadata.Member with the includeProperties flag set to True takes the nearly 2 seconds. I tried using GetUDProperties or using UD.Text() both and all were hit some where with a 2 second cost.
- JackLacava
I wonder if there is some corruption somewhere, like a table that lost its indexes, or a lot of orphans, or a hierarchy that is particularly bonkers. Maybe some optimization could be done at the db level, logging the queries to determine where the slowdown is (you can use ReadMemberPropertiesNoCache to ensure you're hitting the database every time).
In any case, if the api really is that slow, you can speed things up by doing the reading part via SQL directly on the MemberProperty table (you just have to figure out the PropertyID for Text5, but that should be easy enough), and then use the api only for the specific members that need changing.
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 taking place and SOX would likely not like the direct updates. WIll see what this buys us. In any event, this still does not address the 2 second call per member which is terrible.
