In multidimensional data modeling practice, there is the concept of a bridge dimension. A bridge dimension, being the dimensionalized equivalent of a normalized data design’s associative entity, allows for the resolution of a many-to-many relationship. By its very nature, the bridge is saying, “Yes, let’s normalize our dimensional designs.” The bridge dimension exists to resolve a many-to-many relationship between two other dimensions.
