Relationship Manager
The Relationship Manager allows Designers to map a 1:N Relations
In a 1:N relation (one-to-many), one entity is linked to one or more instances of another entity. For instance: 1 Account with 4 Contacts that belong to that account. between two fields and make those relationships available on all data sets within the project.
The Microsoft Dynamics 365 F&O connector retrieves data via an OData Open Authorization query. However, the OData query does not provide access to all of the Microsoft Dynamics 365 F&O data. We've added the Relationship Manager to enable Designers to search on entities and define relationships to resolve this issue.
The Relationship Manager is located in the Connector settings via the Project Console's Control panel.
Figure 1-176 Microsoft Dynamics 365 F&O Connector- Relationship Manager
Import System Relations
The Import System Relations function automatically collates the metadata from Microsoft Dynamics 365 F&O that is often not discovered by an OData query. This list of relationships is standard for a Microsoft Dynamics 365 F&O instance and hard coded to the Import System Relations button.
Figure 1-177 Import System Relations button