Skip to main content
Contributor
Feb 9, 2023 5:03 PM UTC
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 telling us its not possible?

Can it be done through a Workflow using Data Manager?

 

Thanks,

Will

mkohorstAnswer
Member
Feb 9, 2023 8:50 PM UTC

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)

mkohorst_0-1675975798557.png

 

 

 

 

4 replies

Contributor
Feb 9, 2023 7:49 PM UTC

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

Contributor
Feb 9, 2023 9:48 PM UTC

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.

mkohorstAnswer
Member
Feb 9, 2023 8:50 PM UTC

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)

mkohorst_0-1675975798557.png

 

 

 

 

Contributor
Feb 9, 2023 9:49 PM UTC

Thanks for the information!