Product BOM for Dimensional Model
4 posters
Page 1 of 1
Product BOM for Dimensional Model
I am curious to learn the best method for modeling and building into my existing dimensional star schema data mart, the ability to house Product BOM (Bill Of Material) dimensional tables for providing reporting and analysis capabilities for Products. Does anyone have experience with using Product BOM dimensional tables within a star / snow flake schema?
JSpehar- Posts : 2
Join date : 2009-03-17
Location : Michigan
Re: Product BOM for Dimensional Model
If you figure this out, let me know!
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Product BOM for Dimensional Model
Yes... its a hierarchy. Build an exploded hierarchy bridge table and include quantities, UOM, and, maybe, cost as measures. The item dimension is not changed.
The difference between a BOM and a typical hierarchy is that, after explosion, a component may appear multiple times for a given parent (the explosion results in every possible parent-child relationship at any level). If you are not concerned with levels, that is to say all you need is a table that tells you for a given parent, here are the components and their quantities, you can summarize the table by parent/component before using it and don't include level information about the child.
The difference between a BOM and a typical hierarchy is that, after explosion, a component may appear multiple times for a given parent (the explosion results in every possible parent-child relationship at any level). If you are not concerned with levels, that is to say all you need is a table that tells you for a given parent, here are the components and their quantities, you can summarize the table by parent/component before using it and don't include level information about the child.
Re: Product BOM for Dimensional Model
See the following topic for additional discussions on the product hierarchy, a simple example, and links to additional information:
Product bundles
--Warren
Product bundles
--Warren
warrent- Posts : 41
Join date : 2008-08-18
Similar topics
» Product BOM for Dimensional Model
» Complex Dimensional Model Help - With History Product to Part
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Meta-model of Kimball dimensional model
» Complex Dimensional Model Help - With History Product to Part
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Meta-model of Kimball dimensional model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum