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
Solved
Monthly Currency Load Automation
Hello, Currently a brand new customer and I was wondering if there's a way to automate currency loads from a SQL table to load into OneStream? We were told there was a way, but our consultants are t...
From years ago....you probably want to replace the deprecated GetCustomDataTable call with something like this: Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si)
Using dt As DataTable = BRApi.Database.ExecuteSql(dbConnApp, sql.ToString, True)
Hi Will,
Are you referring the FX rates? If you so, yes this is possible using BRApi.Finance.Data.SetFxRate.
We have done it a few times for clients, and even have solutions where we grab daily rates into a custom table, calculate averages and load the result automatically to the FX rate table in OneStream.
Lee
Hi Lee,
Yes, we put load our month end and currency rates (end and average rates) normally form a form, but was curious if there was a way for it to be automated.