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
How to get FX rate from different source?
I have the request to automate FX rates upload. Rates are stored in DWH (Data warehouse) and that would be easy if I could simply connect there. Unfortunately DWH team doesn't allow it, instead of it...
Assuming you're in the cloud I believe your only option for someone to push something from another system into OneStream is via the REST API 'Data Management Execute Sequence/Step' endpoint.
You can either push data in via parameters of the DM sequence or have the execution of the the sequence trigger OS to go and fetch data from somewhere (not exactly a push, more like a poke!).
This is very helpful, thank you Chris! I have already chosen the approach with reading the file with FX files that is available on shared location. I am using WINSCP libraries for it. However thank you once again!
chris_rothermel
OneStream Employee
OneStream EmployeeExcellent. I like WINSCP very much but am not familiar with the libraries. Sounds like something new to learn.
They are often the game changer. Happy to help if you ever have any questions! :)
