02-09-2023 12:03 PM
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 telling us its not possible?
Can it be done through a Workflow using Data Manager?
Thanks,
Will
Solved! Go to Solution.
02-09-2023 03:50 PM
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)
02-09-2023 02:49 PM - edited 02-09-2023 02:50 PM
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
02-09-2023 04:48 PM
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.
02-09-2023 03:50 PM
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)
02-09-2023 04:49 PM
Thanks for the information!