Possibility to dynamically filter out a hierarchy node from a model table

[former_member831270]

Hi Experts,

We have a Profit Center hierarchy coming from S/4 HANA system via the tagged query into PaPM Cloud. Is there any way to dynamically filter out this Profit Center field in a transactional data with profit center node (parent level) from a model table (which stores a PC node) .

Please let us know.

Thank you,

Soundarya C Adiga

[arliesanisidro]

Hi Soundarya,

Good day. As I understand, you would like to filter out a parent level (Profit Center) node in a Profit Center field from a Model Table function.

You can do so by enabling the Hierarchies checkbox for the field and selecting the desired hierarchy in the Fields node of the General Entities section as shown in the below screenshot:

On the other hand, in case the Hierarchies checkbox of field is disabled, the Hierarchy Name would remain disabled and all master data from the Query will be visible.

I hope this helps. Thank you.

Kind Regards,
Arlie