OSAdmin
Valued Contributor

Answer

It is not possible to extract Dynamic Calculations as part of a Data Management job.  One possibility is to bring the data into Stage, then export….to follow-up via e-mail (follows).

Here is the follow up to address your question this morning on the Office Hours call about extracting consolidated data and dynamic calc members.  When using a Data Management Step > Export Data, we only export data that is currently in the database or data the can be aggregated based on the data stored in the database.  So what is this data?

1.Base level data from within the Workflow that is loaded from the Stage to the Cube

2.Base level data from within the Workflow that is loaded via a Forms or Journal

3.Parent Entity level data from within the Workflow that is loaded via a Forms or Journal

4.Calculated data records that were created from the result of Member Formulas/Business Rules based on the base level data

5.Derived data records based on No Data Zero settings

Source:  Office Hours 2019-09-03

 

Comments
Stan
New Contributor II

Is it possible to feed a datatable using a FDX formula :

Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnit() or ExecuteForms

and then transform this datatable into a csv file ?

Version history
Last update:
‎09-14-2023 10:58 AM
Updated by:
Contributors