DataEntity error: Datasource must have at least one relation

(0) Share

Report

Posted on by Community Member

Hello all,

While creating new Data Entity, I'm hit an error like in the subject.

So here is the action:

1. In the new data entity, main data source is table ForecastSales

2. Then add new data source, table InventDim, with JoinMode=OuterJoin and Use Relation=Yes

Aren't the 2nd point, UseRelation means it will take the Relation set in AOT (based on the help text as well). If I checked in AOT of ForecastSales standard, they have relation to InventDim and set the relationkey which is InventDimId.

Why in my Data Entity, still needs to define the relation, if I already set UseRelation to Yes ?

Kindly advice,

Thanks,

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

Does it work with Use Relation=No and setting the relation explicitly, either by name or by manually mapping fields?

I've run into problem with 'Use Relation' too (in D365FO) and I tend to use the other approach in data entities.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin,

Yes, if set to No, And set the relation name after add new relation like below:

and I bet, by specifying the field explicitly (field and related field) will also work.

So, it's just not working then, for the UseRelation ?

Thanks,

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Wwong,

I have faced the same issue before, while adding data sources manually in a data entity. Adding relations manually resolved the issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hmm.. ok.

So probably this UseRelation is not meant for Data Entity then.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi WWong,

UseRelations works if the child table has a relation. For an example, RetailCustTable has a relation with CustTable.

In the CustCustomerDetailsV2Entity, UseRelations is marked on RetailCustTable and the same relation is picked up.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi WWwong,

Another example similar to your entity is SalesOrderHeaderV2Entity. SalesTable has a relation "WorkerSalesTaker_FK" with table HcmWorker related to WorkerSalesTaker field. In the entity the relation is specified explicitly and the UseRelations is set to "No".

So, this property works only if the relation is on the particular dataset (as is the case with RetailCustTable above).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Gunjan,

I think that too has been put manually.

At first, based on your description, I thought it will works if the parent data source of data entity is actually the "child" of a table in AOT then the relation in that data entity is "parent" in AOT. So I just tried to add again ForecastSales as the child of InventDim and put UseRelation to Yes. Still the same error.

Btw, InventDim did has a relation in ForecastSales,

So I guess, it is not working for Data Entity.

Thanks,

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

I think that's correct. Maybe it works only if you use the data entity creation wizard.

Was this reply helpful? Yes No