Forum Discussion

ED's avatar
ED
New Contributor
4 months ago

Parent Filter in Data Management Step

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.

Data Management
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    4 months ago

    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.

  • KarlT's avatar
    KarlT
    Contributor III
    3 months 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,