microsoft / CDM

The Common Data Model (CDM) is a standard and extensible collection of schemas (entities, attributes, relationships) that represents business concepts and activities with well-defined semantics, to facilitate data interoperability. Examples of entities include: Account, Contact, Lead, Opportunity, Product, etc.
https://powerplatform.microsoft.com/en-us/common-data-model/
Creative Commons Attribution 4.0 International
1.66k stars 525 forks source link

CDM and relationship for entities spanning across multiple model.json #115

Closed Deepanshu2017 closed 4 years ago

Deepanshu2017 commented 4 years ago

Hello,

Let's consider this scenario

Second

Above we have 2 dataflows and 2 entities and we have 2 model.json, 1 for each dataflow. Now I have a many to one relationship between Cases.ContactId and WebsiteUsers.UserId where One WebsiteUser can have multiple Cases.

How can I specify this kind of relationship in CDM model? Do I need to update both the model.json? If yes, what should be the update? Do I also need to add references? What kind of references do I need to add?

llawwaii commented 4 years ago

Hi,

I'm sorry for the late response. Could you please share more details? It would help us better how the scenario is like. (e.g. what do you want to achieve by using CDM?)