I am trying to write a BR to update the Global Time within the OS application. I see API function to get globaltime (BRApi.Workflow.General.GetGlobalTime). However, I don't see one for setting/updating global time. Is there a API to update the Global Time?
I even searched the tables in the Database to see if I can manually update the record within a table, but didn't come across the table that contains the Global Time.
Is there a way to update the Global time based on the system time?
I tested it again in lower environment and you were right it doesn't update correctly.
I checked with OneStream support and BRApi.Utilities.GetApplicationProperties(si).GlobalTime will only hold cached values. It won't update it at the DB level.
Now, I'm also moving to SQL solution suggested by bilbrandon.
I have used below SQL code to update the Global time but is not updating and also written BR but that is also not working out can one pls help me on this.
CASE WHEN Textvalue='2023M5' then '2023M6'
End as Textvalue