About
The relationships modeling in OBIEE.
Articles Related
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 :
- create a Bridge table that resides between the fact table and the dimension table. A bridge table stores multiple records corresponding to that dimension.
- add the join in the logical table source (LTS)