Forum Discussion
Solved
Exporting Data automatically to outside of OneStream
HI
I am trying to automate a data extract process to send data from OneStream to another system eg Anaplan. I have a data Mgmt job to Export the data to a CSV on the file share. I now want to move ...
If you are not afraid of Business rules, you should try to use the Fdx functions within BRAPI, they are creating a datatable object and they are retrieving the data very fast, they are all starting with
BRApi.Import.Data.Fdx<Something>
Are you on prem or in the cloud?
We are cloud for OneStream and need many different applications to consume the OneStream data. I set up automation to export to SQL Server so that we don't have to deal with the hassles of files. If you don't have an external SQLconnection, one would need to be set up. Next create a business rule with a query to get the data you want and write it to the SQL table. Set up a Data management step and sequence. Finally, create a OneStream Scheduled task to run the data management sequence for the daily/weekly/monthly schedule you want the process to run.
Hi Scott!
Which tables in Onestream store the parent-child members? I saw the dimension table as well as member table but cannot find the one that has the parent-child relationships
Relationship table.