OBIEE - How to model the different relationships ?

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

The relationships modeling in OBIEE.

3 - Relationships

3.1 - One-to-Many

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 :

Advertising

3.2 - Many-to-Many

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 :

4 - Reference