I will start backward. Show what the result is and then will go into what I did to achieve this. Lets say you want to filter the customer records based on the department dimensions that are assigned to the user logged in. This might include restricting the sales orders too based on those customers. Result Setup Create a new Organization hierarchy with the Security purpose assigned. Edit the hierarchy and add the departments you plan on using. Create a new security role and assigned organizations by specifically granting access to the departments. Technical Now for the technical aspects of this. I used security policies to achieve this result. xds temp table which I have a the code to build (explode) the departments into the temp table. Query which joins the customer table to the dimension tables so we can specifically get the Department dimension Class created a method to retrieve the Department dimension attribute recId New role which is a main driver of the roles
All things Microsoft Dynamics 365 Finance and Operations