topic Re: Hierarchy BOM in App Development

Hierarchy BOM

noahfels — Tue, 19 Oct 2021 07:12:19 GMT

I have a BOM which look like this:

BOM:
Load * Inline [
Item_Parent, Item_Child, Amount
29M20, Z16, 1
29M20, Z17, 1
29M20, L00, 1
L00, R00, 2
R00, K10, 1
R00, K20, 1
R00, K30, 1
R00, K40, 1
20M20, L00, 1
];

My goal is to calculate the quantity needed for each item below the one I select.

E.g. if I select 29M20 then I want to know that I need 1xZ16, 1xZ17, 1xL00, 2xR00, 2xK10, 2xK20, 2xK30, 2xK40.

I have tried using hierarchy loads but I don't get the desired result, perhaps I am using it wrong.

Re: Hierarchy BOM

abhijitnalekar — Tue, 19 Oct 2021 07:42:24 GMT

Hi @noahfels ,

Please try the below Expression.

=aggr(concat(Amount&'X'& Item_Child,',') ,Item_Parent)

Re: Hierarchy BOM

noahfels — Tue, 19 Oct 2021 07:50:12 GMT

In that case I only get the amount of the direct children, but I need to get the amounts and the link to all children_items below a parent_item.

Re: Hierarchy BOM

abhijitnalekar — Tue, 19 Oct 2021 08:05:16 GMT

Hi @noahfels ,

My bad, I was not able to get the requirement correct in the initial reply.

Please create hierarchy like below. Hope this will solves your purpose.

Re: Hierarchy BOM

noahfels — Tue, 19 Oct 2021 08:30:55 GMT

Thanks for your reply, but this still doesn't solve the issue. If I select 29M20 now, I still do not get any information that this item includes 2 x R00 and therefore 2 x K10, K20, K30 and K40.

Re: Hierarchy BOM

abhijitnalekar — Tue, 19 Oct 2021 08:37:24 GMT

Hi @noahfels ,

I am afraid that I am not able to understand the requirement properly.

As per the inline-table, you have given the parent 29M20 have 1XL00,1XZ16,1XZ17. Please correct me if I am wrong.

Can you please share any diagram or table how you want the output

Re: Hierarchy BOM

noahfels — Tue, 19 Oct 2021 08:48:43 GMT

Correct @abhijitnalekar , but since one 29M20 includes one L00, therefore it also includes all child_items of L00 (i.e. 2 x R00). And R00 itself has four child_items (i.e. K10, K20, K30, K40). Therefore 29M20 includes 2 x R00 and 2 x (K10, K20, K30, K40). It is a bill of materials structur which is build like a hierarchy (tree). I think some form of a hierarchy load is needed.

Re: Hierarchy BOM

Saravanan_Desingh — Tue, 19 Oct 2021 13:33:36 GMT

I think, your expected output is wrong.

For 29M20, you should get - 1xZ16, 1xZ17, 1xL00, 2xR00, 1xK10, 1xK20, 1xK30, 1xK40.

Try this,

BOM: HierarchyBelongsTo(Item_Child, Item_Parent, Amount, ParentName, Node, Depth) LOAD *, Item_Child As NodeName; Load * Inline [ Item_Parent, Item_Child, Amount Root, 29M20 29M20, Z16, 1 29M20, Z17, 1 29M20, L00, 1 L00, R00, 2 R00, K10, 1 R00, K20, 1 R00, K30, 1 R00, K40, 1 20M20, L00, 1 Root, 20M20 ];

Expressions:

=Concat(Amount&'x'&NodeName, ', ') =Sum(Amount)

Re: Hierarchy BOM

noahfels — Tue, 19 Oct 2021 14:51:46 GMT

This seems to be kind of what I am looking for, but I would have to concatenate an entry for each root item once, correct?

Re: Hierarchy BOM

Saravanan_Desingh — Tue, 19 Oct 2021 15:00:41 GMT

Yes. But the original Table wont be there after

HierarchyBelongsTo

So, you have to use Depth & Node combination to identify the Root.

Re: Hierarchy BOM

noahfels — Tue, 19 Oct 2021 15:11:05 GMT

Right now I am loading the table beforehand, then doing the HierarchyBelongsTo and dropping the original table. So now it seems like I only have to concatenate each root item once with itself as the parent. I think this should work, thank you @Saravanan_Desingh ! However if anyone has a different approach, please share them.