Many-to-many relationship

While designing a relationship, you can create a many-to-many relationship between Fact and Dimension.

A many-to-many relationship occurs when multiple records in one table are associated with multiple records in another table. For example, a many-to-many relationship exists between customers and accounts when customers have multiple accounts, and accounts can be opened jointly by many customers.