Thanks for mention Scott Giffin ! I was going to re-direct you to that exact video until halfway through reading your post, I read that you have seen already . It looks like pretty challenging task. It's possible to do the split at each sub-assembly level if the BOM follows the order of the main assembly.
Thank YOU for your contribution to the community! Yes I am creating the tree exactly the way we want it to be listed in the resulting split BOMs. I'm very new at this part of the design process. I'm fairly familiar with Solidworks but just getting started with the API and macros. I'm new to this company. Before I started here they were using AutoCAD. I'm trying to help them see the advantage of automating the process of creating the drawings in this new environment. They seem to have a far more urgent need right at the moment because the server we use is off site at another location. The speed is not useable for assemblies in Solidworks. I guess I need to research what people are doing to address the issue of sharing data across multiple locations.