OBIEE - How to model the different relationships ?

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 :

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

dat/obiee/obis/relationship.txt ยท Last modified: 2017/09/13 21:21 by gerardnico