How to pull data from sparse dynamic calc member in Data management PBCS
Hello Oracle Community,
I’m working with Oracle PBCS and am trying to pull the parent values of sparse dynamic members using Data Management (DM). However, I’m encountering difficulties in retrieving the parent member values directly.
To provide more context, data entry is done at the level 0 members through forms, where the parent is a dynamic calculation (Dynamic Calc). I would like to automatically capture and include the parent value associated with each dynamic member during the data load process, but I’m unsure about the best approach to achieve this using Data Management.
Has anyone faced a similar challenge? Could anyone share best practices or provide a solution for retrieving the parent values of sparse dynamic members in Oracle PBCS via Data Management? Any insights or advice would be greatly appreciated!