Product Matrix for manufacturing

Posted on 2005-05-09
Last Modified: 2010-03-19
I am trying to put together an app, just as a learning exercise, that a manufacturing plant could use.  The biggest feature that I would like to have is a multi-dimension customized product matrix.  I would like the clients to be able to create a single "product" that has various options to the product to create different products.  Example:  Picture frames.  A specific frame has a profile, a shape, a size and a color.  I would like the client to create a single "product", the profile, that has various shapes, sizes and colors that could be chosen.

I have thought of accomplishing this by having separate tables created for each of these "products", but that would mean that I do not have a single table with all my product codes in it.

Does anyone have any ideas on how to implement a product matrix that allows the users to specify the different dimensions this way?

Thanx in advance.

Question by:SterlingMcClung
    LVL 19

    Expert Comment

    by:Melih SARICA
    Its something like Called  Configurator ..

    Items and features ll create new Items..

    First U must ave an Item Table

    Then Feature Table

    These Features must ave variable Answers or Uniq answers

    and u must ave and ItemFeature Table to create Relation between Items and Features

    then  if u create new Item Codes from These ItemFeature Combinations

    U must ave and FeatureAnswerCode Table

    u ll Join these tables and get the result..

    i know its a lil bit complex.. But i got flu today and feel like a mass.. cant explain more..

    Melih SARICA

    LVL 7

    Author Comment

    It seems like you know what to do, but that did not make much sense to me.

    It seems you are talking about havin three different tables: one will all products in it, one with the different options, and another that says what the features are.  So then would it be something like the following:


    450      Oval        11x14     Rosewood         $50
    450      Oval        11x14     Gold Leaf           $75
    46        0            Oval        8x10       Hunter Green     $25
    46        1            Oval        8x10       Hunter Green     $30

    Product     Feature1      Feature2   Feature3   Feature4    Feature5
    450           Shape          Size           Color       Price
    46             Decoration   Shape        Size         Color         Price

    Is this what you mean?
    LVL 7

    Author Comment

    Is this just way to create all the product/item codes?
    LVL 19

    Accepted Solution

    o.. here is an example


    FeatureID  FeatName
    ----------- -------------
    Feat_1      Shape
    Feat_2      Size
    Feat_3      Color
    Feat_4      Decoration
    Feat_6      Madeof

    (Feat Answers)
    FeatID AnsID AnsNAme
    ------- ------- -----------
    Feat_1 Ovl       Oval
    Feat_1 Pol      Poligon
    Feat_3 blu      Blue
    Feat_3 red     RED

    (Feature by Product Item)
    PrdID Sern Feat ID
    Itm_1  10    Feat_1
    Itm_1  20     Feat_2
    Itm_1  30     Feat_3
    Itm_2 10     Feat_1

    Answersby Item
    PrdID Sern Answer
    Itm_1  10    Oval
    Itm_1  10    poligon
    Itm_1  30    Blue

    then with these tables ur matrix must be created


    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now