can we create a validation which will not allow user to add same property value for multiple bottom

Summary:

 Unable to set up a validation to identify Employee_ID field duplications in all bottom-level nodes.

Content (required):

I am trying to create a validation statement on SALES_REVENUE Dimension for the below requirement, but unable to find a function to achieve the same.

1) any two bottom-level nodes should have the same Employee ID (Core.Employee_ID) in the SALES_REVENUE Dimension. EMPLOYEE_ID can be duplicated in parent nodes.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):