Has anyone done a Birst BOM with LN?

Dan_Rosen · 2025-02-20T22:08:51+00:00

There was an error rendering this rich post.

Figure I'd ask before I spin my wheels on this. Normally I'd think to order all of the rows by the global, parent, component to build out some BOM path strings, but LN doesn't have a global - everything is just parent and component.

My first thought is I could fake a recursion by joining to a bunch of copies of the same table and building it out that way, but was hoping there is something more elegant 😄

Find more posts tagged with

Accepted answers

All comments

Enrico Menotti

Hi Dan,

If I remember right, there is something in Dragon Grid by the folks at Agile Dragon Group. That had been built originally by @CindyHoskey.

Besides that, I guess this may be useful:

https://docs.infor.com/birst/2024.x/en-us/birstdataandmodels/Data/TransformETL/ETL_Services_Script_Functions.html?Highlight=ADDPARENTCHILD#Parent-Child_Hierarchy_Flattening

If you figure that out, please post here, I'm interested as well.

Enrico

Dan_Rosen

Checking out those docs, the top down flattening does seem to align with what I'm talking about. Now if only they actually provided an example of how to implement it or what an output would look like. I'll have to poke around some more and see what I can find. Thanks!

Enrico Menotti

https://community.infor.com/infor-birst/f/admin---data-modeling-and-self-service-data-prep/20530/nextchild-parameter/60518#60518

There was a plethora of posts, blogs, etc. in the old Infor Community. There was even more in the even older Birst Community (I mean the one hosted by the original Birst company), only part of which has been migrated to the old Infor Community. I had asked @Riina Silverberg for the oldest Birst Community content, but it seems that Infor has scrapped it. ☹️

Enrico Menotti

https://community.infor.com/infor-birst/b/legacy-blog-posts/posts/hierarchy-flattening-top-down-approach-etl-script-multiple-parent-with-multiple-child

Dan_Rosen

Yep this is the one I was reading as well - looks like a good example though I'd need to fully test it out to see what it's actually doing. I might play around with that a bit and see if it makes sense over the joining approach.