How to design a Bill of Materials stream

Does anyone have any ideas on how to create a stream and dimension like in the “Tackle your Bill of Materials - session one” video on Lunch and learn

I have an orders transaction stream and an extensive Products dimension. I’ve also created an Enumerated BOMs data source which explodes the BOM so all components in a product are listed next to the top level product code and includes the level of the bom the component is in. The columns are BaseItem, BomID, BOMLevel, ItemID, BOMQty.

Thanks!