We are under construction!
You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.
You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.
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
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 ?