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

[Sridhar_M]

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

Sridhar 

[Henning]

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]

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]

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.