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

Sridhar_M's avatar
Sridhar_M
Contributor
2 years ago

Is it safe to export data from cube using FDX queries (FdxExecuteDataUnit) during consolidation ?

Hi All,  We are using FdxExecuteDataUnit to export data to SQL tables for consumption by downstream systems. Is it safe to run FDX queries while consolidation/Data Loads is in progress ? Regards ...
Data Integration
Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi Sridhar,

I assume you want to export data after it has been calculated / consolidated as otherwise your data export may not include the complete and processed data set. It seems to be more a matter of process rather than "technically" safe. Ideally this is embedded as a proper process in the workflow, or by using Task Manager. 

For example like this:

Load --> Process (e.g. consolidate) --> Confirm ( Certify) --> Export

Sridhar_M's avatar
Sridhar_M
Contributor
2 years ago

Hi Henning, 

Thanks for the response, The audience who eventually have access to this job has no access to workflows, we just wanted to give them access via dashboard to click a button which calls Data Management job that executes FDXExecuteDataUnit and exports data to a table.

  • Henning's avatar
    Henning
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    Hi Sridhar,

    regardless of how they get the data, they still depend on the data being available properly in my view (without knowing your process, of course).

    How about instead of giving the 'audience' access to a dashboard with a button, automate this? Not sure how this data needs to be exported, but typical ways to address this are to create scheduled (overnight) jobs with task scheduler. This can be e.g. daily, weekly,...
    Or you could embed it as part of the process, e.g. once a period or a certain workflow step is closed, the export file will be created.

    The file can then just be pushed into a directory where your users need it.