Forum Discussion

Tahir2061's avatar
Tahir2061
New Contributor III
4 years ago
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 ...
Data Management
FileSystem
  • ChristianW's avatar
    ChristianW
    4 years ago

    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>

     

     

ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
4 years ago

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>

 

 

mike's avatar
mike
New Contributor II
4 years ago

Hey Christian, how does the filter parameter for the FdxExecuteDataUnit method work? It's a string and I assumed it would be similar to the Data Management extract filter (i.e. something like "A#All:U1#Top:U2#Top" etc) but that's not working. It doesn't like the syntax of having the # in the string.

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    4 years ago

    Hi Mike

    Sorry for the late answer. The filter works like in an sql query's where statement: "Account = 'Test' or Flow='None'"

    Cheers