can we create a validation which will not allow user to add same property value for multiple bottom
Unable to set up a validation to identify Employee_ID field duplications in all bottom-level nodes.
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):