OBIEE - How to model the different relationships ?

About

The relationships modeling in OBIEE.

Relationships

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 :

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 :

Reference


Powered by ComboStrap