MICROSTRATEGY TUTORIALS

Many-to-many
In a many-to-many relationship, each element in the parent
attribute is related to more than one element in the child
attribute, and each element in the child attribute is related to
many elements in the parent.
In a car manufacturing plant, many models of cars are
produced, and each comes in several colors. That is, there are
many colors for a single type of car, and many types of cars
can be associated with the same color.



Many-to-many relations can be a particularly tricky data
modeling scenario. Additional information can be found in
Appendix D, Advanced Data Modeling.