In AX2012 & AX7 / D365 there is already a view named EcoResProductAttributeValue but it cannot provide textual data instead it gives the Record Id's of multiple data sources. In my view I have use EcoResProductAttributeValue view but I have displayed values that is more meaningful as per my task context.
Simply I have created a query in which I drag and drop all the related datasources.
1- EcoResProductAttributeValue
2- EcoResAttribute
3- EcoResProduct
4- EcoResTextValue
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSGejjBITMWyOx1sJISl6u_pdemJLiarv8RVy1dpsUH0VE2NvLCirRN_hDF7jsK8o4H4mtTofZKOvOfCI5LRGI-sBf0qJ3nhCoqY6XMIRI52fU5ML_QeCqwWykCpwrcNIYUjrKpU6mkhg/s400/2.png)
After that I have created relations as shown in image.
No comments:
Post a Comment