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.

Knowledge Base Article

Is it possible to extract consolidated data, including Dynamic Calcs?

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

 

Updated 2 years ago
Version 3.0
  • Stan's avatar
    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 ?