This error occurs at on standar AX View because i add new relation on Derived table.
example base table :
how to fix it :
1. At the example views QUERY HcmBenPolWkrPosDtlInfo, find OMOperatingUnit datasource, and find the relation on the table.
2. Set the RELATIONS properties to NO on query datasource table , then right click on the relations, add new relations and manually configure the tables relations, do this for the all base table in datasource too
3. Then restore the query views, do restore to on the views, then re-compile the view
Advertisements
Also check groupby of the first DS, it cannot contain fields from the related DS, only the main table.