Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Product BOM for Dimensional Model

4 posters

Go down

Product BOM for Dimensional Model Empty Product BOM for Dimensional Model

Post  JSpehar Tue Mar 17, 2009 1:13 pm

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

Back to top Go down

Product BOM for Dimensional Model Empty Re: Product BOM for Dimensional Model

Post  BoxesAndLines Wed Mar 18, 2009 9:25 am

If you figure this out, let me know!
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Product BOM for Dimensional Model Empty Re: Product BOM for Dimensional Model

Post  ngalemmo Tue May 19, 2009 2:11 pm

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.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Product BOM for Dimensional Model Empty Re: Product BOM for Dimensional Model

Post  warrent Wed Jun 10, 2009 3:38 pm

See the following topic for additional discussions on the product hierarchy, a simple example, and links to additional information:
Product bundles
--Warren
warrent
warrent

Posts : 41
Join date : 2008-08-18

Back to top Go down

Product BOM for Dimensional Model Empty Re: Product BOM for Dimensional Model

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum