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>

     

     

Gidon_Albert's avatar
Gidon_Albert
Contributor II
4 years ago

scottr's approach is the way to go. Exporting base level data to a file and then pushing it into an external SQL database is very fast. The only down side of this approach is that exporting parent members can really put a damper on performance. To avoid this, we developed a two step process: 

  1. Export the parent child relationships for all the dimensions into external SQL tables
  2. Export base level data from the cube to an external table

This method is much faster than exporting all data out of OneStream but puts the burden of doing the aggregation math on the external SQL table.

 

Tahir2061's avatar
Tahir2061
New Contributor III
4 years ago

HI Gidon

Thanks for replying - that sounds like a good approach will have a tinker!

Thanks!

Tahir