What is fastest method/best practice to find BOM depth of a given assembly?

[yxin]

We have custom BOM report page which by default shows only the first level of components. However, on the page the user is given the option to expand the BOM to any available depth. To display the available number of levels, the program needs to find the total number of levels. This is quite heavy on a big assembly, and many times unnecessary when a user wants to see the first level only. I wonder if there are better ways to get the total depth of a given assembly without walking the whole product structure tree.

[ScottMorris]

This is a great question. You can run the Multi-Level Bill of Materials report which includes the "Level" column and scan through it or export to excel to find the highest level. Would be nice if the total number of levels was displayed for the top level in the product structure or there was a way to add the Level column to the PS.

[HelesicPetr · Accepted solution]

Hello @yxin 

There isn't better way then go through all levels because information about depth is not sorted in a database.

PetrH