Skip to main content
E
ED2
Newcomer
August 30, 2024

Parent Filter in Data Management Step

  • August 30, 2024
  • 2 replies
  • 0 views

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.

issue_specifying_parent_filter.jpg

2 replies

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
September 2, 2024

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.

K
OneStream Employee
KarlTOneStream Employee
OneStream Employee
September 17, 2024

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,

Terms & ConditionsAccessibility statement