- From the Modeling tab of the Report or Data view, select Manage Relationships and click on New.
- Create many-to-one, single direction relationships from each fact table to its corresponding dimension table.
- Date data type columns should be used for the Date table relationships.
Relationships view of a multi fact data model
- Bidirectional relationships should only be implemented with clear guidance and evaluation.