08-29-2024 09:27 PM
Hi,
I'm having difficulties trying to specify the Parent Filter in the data management step and was wondering if anyone has encounter this before and can suggest a better approach.
I'm creating a data management step to trigger custom calculate elimination rule and trying to specify multiple parent members however it doesn't seem to work properly.
When debugging the BR, i can see api.pov.parent is returning nothing whenever multiple parent members are specified in the parent filter of the Data Management Step.
It does work properly when a single parent member is defined, but this means I need to create multiple data management steps to triger the same calculation.
Below is the illustration of this scenario. Appreciate all the help/advise i can get. Thank you.
09-02-2024 06:06 AM
From quick tests, it looks to me like Parent is not really a filter, and will only accept a single member (or a list of 1 member), or blank. You might want to talk to Support about that.
A workaround would be to pass your filter as a parameter instead, and then deal with this into the rule itself.
3 weeks ago
Hi ED,
I may be wrong on this as it's been a few years since i tried it, but i thought for some DM steps you can "pair them up". So if your entity filter is "E#EntityA, E#EntityB, E#EntityC" and your parent filter is "E#Parent1, E#Parent2, E#Parent1" it will pair up this first items in each list (E#EntityA:P#Parent1), then the second (E#EntityB:P#Parent2) and so on.
As i say, i haven't tested this and maybe i am dreaming haha, but could be worth testing
regards,