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
