Is it possible to export Parent members/Dynamic calc members using Export Data Job
Summary:
Hi everyone,
I am trying to export data using the Export Data job (Overview > Actions > Data Export). I would need to export the P&L hierarchy (including parent levels which are dynamic calc).
This job works fine when only level 0 members are selected in the Slice definition ,but the job fails if parent or dynamically calculated members are included (for Account dimension, which is a dense dimension).
For Period dimension (also dense) I selected lowest level members (Children of YearTotal) which are the months. For all other dimensions (sparse), I selected Level 0 members as well. The job fails, from the moment one dynamic calc member (in any dimension) is selected.
Tagged:
0