The relationships modeling in OBIEE.
Star schemas and snowflake schemas work well for modeling a particular part of a business where there are one-to-many relationships between the dimension tables and the fact tables :
However, sometimes it is necessary to model many-to-many relationships between dimension tables and fact tables. When you need to model many-to-many relationships between dimension tables and fact tables, you can :