# How to design a Bill of Materials stream

**URL:** <https://pug.phocassoftware.com/t/how-to-design-a-bill-of-materials-stream/2606>\
**Category:** Ask the Community\
**Created:** [November 24, 2023, 6:26am UTC](https://pug.phocassoftware.com/t/how-to-design-a-bill-of-materials-stream/2606 "2023-11-24T06:26:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jordon](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@Jordon](https://pug.phocassoftware.com/u/Jordon)\
**Post date:** [November 24, 2023, 6:26am UTC](https://pug.phocassoftware.com/t/how-to-design-a-bill-of-materials-stream/2606/1 "2023-11-24T06:26:00Z")

</div>

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](https://www.phocassoftware.com/lunch-and-learn-2020-recordings)

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!